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.