Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
gordostogo
New Member

How do I delete a source showing in my linage to a data flow?

Hello, 

 

How do I delete a source showing in my linage to a data flow?

 

gordostogo_0-1622660224333.png

Thanks,
Gordon

1 ACCEPTED SOLUTION
v-robertq-msft
Community Support
Community Support

Hi, @gordostogo 

As far as I’m concerned, the data sources in your dataflow correspond to the tables in your data flow, when you delete the tables(Queries) in the data flow, the corresponding data source will also be removed, you can try my steps:

  1. Click on the data flow and edit table:

v-robertq-msft_0-1623146286588.png

 

  1. Select the tables corresponding to the data source you want to delete:

v-robertq-msft_1-1623146286590.png

 

Then apply and close to check if the data source can disappear.

 

Creating a dataflow

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
v-robertq-msft
Community Support
Community Support

Hi, @gordostogo 

As far as I’m concerned, the data sources in your dataflow correspond to the tables in your data flow, when you delete the tables(Queries) in the data flow, the corresponding data source will also be removed, you can try my steps:

  1. Click on the data flow and edit table:

v-robertq-msft_0-1623146286588.png

 

  1. Select the tables corresponding to the data source you want to delete:

v-robertq-msft_1-1623146286590.png

 

Then apply and close to check if the data source can disappear.

 

Creating a dataflow

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

gordostogo
New Member

Hi Fowmy,

 

I do not want to delete the dataflow because it feeds the dataset and report, I just want to delete three of the sources that are showing connected to the dataflow. 

@gordostogo 

They are connected to your report, deleting them will cause the report to fail. can you provide more details on what exactly is needed?

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

I initially built the report attached to the first data set shown at the top of the lineage.  I added the other three on accident trying to get the data stored in a location where others can access it, thus leaving me with three other items.  Unfortunately, the other three I wasn't able to connect because of credential issues.  But I would like to get me back to where i was with the one source.    I really appreciate you taking time out of your day to help me. 

  

First, click on edit your table in the data flow, click on manage connections, and then delete the undesired connection.

 

Reza188_0-1688150297508.png

 

Reza188_1-1688150644909.png

 

Fowmy
Super User
Super User

@gordostogo 

Why don't you delete the data flow if it has only this query or delete this particular query from the Data Flows

Fowmy_0-1622660512692.png

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.