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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Lineage View - Datasets and Dataflows

I have a datasets (dataset1) in a workspace (workspace1) connected (import mode) to a dataflow (dataflow1) in another workspace (workspace2)

 

When I view  the lineage of the dataset1, I can see the dataflow

 

When I view the lineage of the dataflow1, it doesn't show where this dataflow is used i.e. I can't see it is used in to dataset1 in workspace1. 

 

Is this the expected behaviour of the lineage, i.e.  you cannot see the artifacts of a dataflow (or any datasource) if it is used in another workspace?

1 ACCEPTED SOLUTION

I think you can build a script with the Power Bi Rest API. You can first take all the datasets:

https://docs.microsoft.com/en-us/rest/api/power-bi/admin/datasets_getdatasetsasadmin

Once you have those in a table or dataframe you can run for each one of them the request for data sources:

https://docs.microsoft.com/en-us/rest/api/power-bi/admin/datasets_getdatasourcesasadmin

After you organize your json response for each row you might be able to check the connectionString or connectionDetails looking for dataflows in order to see which datasets are using dataflows.

Hope that helps,


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

Happy to help!

LaDataWeb Blog

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Thanks @ibarrau makes sense. Is there any othe way to find out where a dataflow is used? 

 

Just want to know the impact before we delete a dataflow

I think you can build a script with the Power Bi Rest API. You can first take all the datasets:

https://docs.microsoft.com/en-us/rest/api/power-bi/admin/datasets_getdatasetsasadmin

Once you have those in a table or dataframe you can run for each one of them the request for data sources:

https://docs.microsoft.com/en-us/rest/api/power-bi/admin/datasets_getdatasourcesasadmin

After you organize your json response for each row you might be able to check the connectionString or connectionDetails looking for dataflows in order to see which datasets are using dataflows.

Hope that helps,


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

Happy to help!

LaDataWeb Blog

Anonymous
Not applicable

@ibarrau perfect, that makes sense. I will give it a go

 

Nishant

ibarrau
Super User
Super User

Hi. Yes, that's the expected result microsoft has proposed. It will show only the sources of the components. When you check view in the dataflow it can't show in which dataset it's used because that's not the objetive, that's not a data source. The dataflow is the data source for the dataset. That's why you can only see it from one direction.

 

Hope that make sense


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

Happy to help!

LaDataWeb Blog

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors