Forum Discussion

HankScorpio's avatar
HankScorpio
Frequent Visitor
2 years ago

Delete Data from model when file deleted from folder

Hi Everybody   Wanting to know how to configure PowerQuery in PowerBI to delete data from the data model when the file is deleted from the source folder.    Currently I have set up a folder to co...
Need Help
BA_Pete's avatar
BA_Pete
Super User
2 years ago

Hi HankScorpio ,

 

The natural process of Power BI data refresh is to wipe all data from the model, reconnect to all sources in their curent state, and import the data as it exists at that time. Therefore, performing a refresh on each component of your data chain in the correct order will give you the results you're looking for.

For example, if you have 3 CSV files in a folder which are fed into a Dataflow for transformation, then imported into a data model, you need to follow the steps in this order:

Delete CSV file > Refresh Dataflow > Refresh data model. If your report is in the PBI Service, you may also need to use the Refresh Visuals button in your Service report, and/or refresh your browser. In very rare cases, you may also need to fully refresh your browser's cache as well.

 

Pete