Forum Discussion
Solved
Setup Incremental refresh
Dear all I am new with Power BI desktop, I have a huge amount of daily excel files stored in local harddisk, and imported to PBI by folder. It take ver long time to refresh data when I have a new dai...
Please see this video. You can leverage incremental refresh when combining files. In your case, you need a gateway to get to local files from the service. Or, preferably, store you files on a SharePoint site.
https://www.youtube.com/watch?v=IVMdg16yBKE
Pat
Thanks for the reply. But from the link provided it also mention it also support excel files in folder. Have I missunderstand?
Please see this video. You can leverage incremental refresh when combining files. In your case, you need a gateway to get to local files from the service. Or, preferably, store you files on a SharePoint site.
https://www.youtube.com/watch?v=IVMdg16yBKE
Pat