Forum Discussion
Solved
Exclude from refresh certain files for a folder data source
Hi All, I thought that it would be simpler to just connect to a folder instead of connecting to multiple files one by one and then appending them to a new query. It worked fine but I realized tha...
Well, I ended up separating my data sources into current and old folders. Thanks for this.
Hi danextian,
In Power BI desktop, we can enable/disable a query to be refreshed when clicking on the Refresh button in the top ribbon in query edit mode.
Right click one query and select the last option 'Properties'.
In your scenario, when you load multiple files into a single query, it is not possible to exclude some certain files when refreshing data source. The only workaround is to load files into Power BI as different queries, then, append them into a new query according to your need.
Best regards,
Yuliana Gu
Well, I ended up separating my data sources into current and old folders. Thanks for this.