Forum Discussion
Delete Data from model when file deleted from folder
Hi
I have deleted the csv file. I ran refresh in PowerWuery, is that the same as refreshing the model?
Because I have done that and the data still remains even with the file gone.
The only way I was able to get the data to delete was to change the source folder. But I can't do that every time.
If you're doing all of this in PBI Desktop (assuming you're not using any Dataflows or datawarehousing of the CSVs) then you would need to:
1) Delete CSV
2) Go to the Home tab in the report view (not Power Query Editor) and hit Refresh:
If your report has been published to the PBI Service then you would need to:
1) Delete CSV
2) Find the Semantic Model in the workspace and refresh that:
Refreshing in the Power Query Editor just refreshes the previews in PQ, it doesn't refresh the model itself.
Pete
