Forum Discussion
Obsolete data sources in dataflow lineage
Sorry, but your workaround doesn't address the bug. If I click on the arrows for the dataflow, all 7 upstream data sources get highlighted. Only one of them is valid, the others should not exist, and they provide bad intelligence.
My (horrible) workaround is to export the dataflow as json, delete the dataflow and then reimport the json to a new dataflow. When I do this, the lineage diagram correctly shows just a single datasource for the dataflow. Of course this breaks every single usage of the dataflow, so in a high-usage scenario this would be unacceptible.
Hi JenM ,
If so ,I have a simple way for you:
Connect the dateflow in desktop,then go to data source setting and clear your data source then reenter it:
Finally save as a new report or cover the previous report and publish to service.
I guess this way will help solve your issue.
Kelly
- JamesDBartlett32 years agoAdvocate II
The question was how to remove old Data Sources from a Power BI Dataflow, not a Report in Power BI Desktop. Please see the answer posted by EG151 above, which actually resolved the issue: Re: Obsolete data sources in dataflow lineage - Microsoft Fabric Community
- SaiTejaTalasila2 years agoSuper User
Hi JenM ,
You can edit the power queries and you will be able to change the data source.
Thanks,
Sai Teja