cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors