Slow data refresh when connecting from SharePoint Folder

Question

Hi Team,&nbsp;&nbsp;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.&nbsp;&nbsp;Is there any way to improve refresh timing for this?&nbsp;&nbsp;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.&nbsp;&nbsp;Thanks

amitchandak · Answer

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. 
&nbsp;

&nbsp;

negi007 · Answer

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

An introduction to Power BI Dataflows (sqlshack.com)
Dataflow Vs. Dataset: What are the Differences of these two Power BI Components - RADACAD

anonymous · Answer

Hi&nbsp;amitchandak&nbsp;,&nbsp;Thanks for your response.&nbsp;&nbsp;I have depenedency of Auto Date/Time property which should be enabled.&nbsp;&nbsp;except that property , I have tried other settings which you have suggested , This causes slight improvement but not the significant.&nbsp;&nbsp;If any other suggestions are there , please let me know. Appriciate your help on this.&nbsp;Thanks&nbsp;

Forum Discussion

Slow data refresh when connecting from SharePoint Folder

3 Replies

Related content

Incremental Refresh on Dataflow sourced from SharePoint

OData Error When Connecting to SharePoint Online

Sharepoint Connection

Connecting to sharepoint

Power Query SharePoint Connections Refresh Speeds