Apply query changes takes (too) hours

[Anonymous]

Hi all,

I have made an function with PowerBI. In the function i see all the metadata fields from a SharePoint sites. The sites have around 40 library with a total of 10.000 files, not that much i think? When i selected all the libraries in my function and load the query it take many many hours to apply query changes. After 10 hours i have to close my computer and the connection is lost. 

How can i resolve this problem? When i just select 1 library it works but i need to select all the libraries. Can i use a sort of schedule?

[v-lili6-msft · Accepted solution]

hi @Anonymous 

I think you need reduce your datamode size, reomve unnecessary columns and reduce unnecessary steps.

Of cource, you need to upgrade your hardware of PC.

Regards,

Lin

[Anonymous]

Thanks for your help, i will look into the extra columns.