I have about 200 SPOnline sites(webs) with a set of documents on each site. I need a consolidated report on the documents status from all sites. The document libary columns are simple no lookup columns etc.

My power BI guys claims he is facing performance issues/ timeouts when retrieving data from more than a few webs.