Forum Discussion
Trebor84
5 years agoHelper II
Remove old unused data source
Hi, I have a table in my report that pulled data from files from a folder on my PC. I have now changed the data source in the power query editor to refer to a SharePoint.Folder instead of my...
mkiewra
2 years agoFrequent Visitor
Another reason for which you can see old data sources are unused power query transformations. It can happen if the pbix file is copied and some old Power Query transformations are left in the pbix file.
In my case the following solution worked:
1. Open any existing power query transformation.
2. Find unused queries on the left side of Power Query editor
3. Remove unused queries
Once all unusued queries are deleted, unused data sources disappeared.