Forum Discussion
Remove Obsolete Source from Lineage View
Hi,j_ocean
Regarding the issue you raised, my solution is as follows:
First of all, you can change the part of the data source source you need to modify, Ctrl+select in PowerQuery, and click Copy to preview the data:
Then click EnterDate to paste the data and delete the query that references other data sources, so that your data comes from the parts you manually entered and not from other data sources:
Next, find the options and change the gateway to none:
Change the gateway used in a dataflow project - Power Query | Microsoft Learn
This way, there is no relational data source before the dataflow:Of course, the limitation of this method is obvious: the data cannot be too large, and the data structure cannot be changed.
If you have any new ideas, you are welcome to contact us.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
For anyone reading this later, this did not solve the issue. MSFT accepted their own solution.
I've given up and am enduring with the reupload-json method mentioned in the original post.
It appears from your final image vs the first that you simply refactored the system to be all in the pbix, which is not what I need.
You started with
SQL → Dataflow → Semantic Model → Report
I need
Dataflow → Semantic Model → Report
Not
SQL → Semantic Model → Report
Hi,j_ocean
Regarding the issue you raised, my solution is as follows:
First of all, you can change the part of the data source source you need to modify, Ctrl+select in PowerQuery, and click Copy to preview the data:
Then click EnterDate to paste the data and delete the query that references other data sources, so that your data comes from the parts you manually entered and not from other data sources:
Next, find the options and change the gateway to none:
Change the gateway used in a dataflow project - Power Query | Microsoft Learn
This way, there is no relational data source before the dataflow:
Of course, the limitation of this method is obvious: the data cannot be too large, and the data structure cannot be changed.
If you have any new ideas, you are welcome to contact us.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
For anyone reading this later, this did not solve the issue. MSFT accepted their own solution.
I've given up and am enduring with the reupload-json method mentioned in the original post.