Slow data refresh when connecting from SharePoint Folder

[Anonymous]

Hi Team, 

Is there any way to import data faster when it is taking from SharePoint folder. I have experinced Most of the times status of table refresh are "Evaluating" or "Waiting for Other queries" ( Other queries status would be again evaluating), Even small data present in excel which are taken from sharePoint folder also will take Huge time to load in PBI. 

Is there any way to improve refresh timing for this? 

One strange observation : Even when Internet connection is disabled in Local system also will show status "Evaluating". I was expecting status should be connection terminated. 

Thanks

[negi007]

@Anonymous if possible you can use dataflow in powerbi services which is much faster and efficient way of extracting data from sharepoint folder

An introduction to Power BI Dataflows (sqlshack.com)

Dataflow Vs. Dataset: What are the Differences of these two Power BI Components - RADACAD

[amitchandak]

@Anonymous , Try these settings and increase the memory management cache. Clear Old memory management cache before loading. Make sure the hard disks has more than 20 GB of free space.

[Anonymous]

Hi @amitchandak , 

Thanks for your response. 

I have depenedency of Auto Date/Time property which should be enabled. 

except that property , I have tried other settings which you have suggested , This causes slight improvement but not the significant. 

If any other suggestions are there , please let me know. Appriciate your help on this.

Thanks