Forum Discussion
hansei
6 years agoHelper V
Previews are refreshing automatically
I have a report that gets Excel data from SharePoint folders. There are around 30 files and ultimately around 12 tables ranging from 50-300000 rows. If I choose to do 'Refresh All' from the Power Que...
v-frfei-msft
6 years agoCommunity Support
Hi hansei ,
In your scenario, I suggest to Configure scheduled refresh for your dataset in power bi service insteading refreshing your data in power bi desktop. For more details, please check the online document.
https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh
hansei
6 years agoHelper V
How is that of any help to my issue: which, to iterate, is that anytime I want to edit a query I have to wait hours beforehand?