Is it possible to tell which reports are using dataflows?

[Dragon496]

Hello

We have a handful of dataflows, but would like to reorganise them into folders. Before we start moving dataflows, it would be useful to know if and which reports are using the dataflows-so we can notify the report designers.

I have searched the Internet, most of the day, without success. Is it possible to work out what reports are using dataflows?

We already have quite an extensive history solution, whereby we downloaded the data catalogue information, from our tenant each day and therefore have built up a history. However, I had tried joining up report, dataflow, dataset, data sources, however I have been unable to extract the data we require.

Any ideas?

Thanks

[Anonymous]

Hi, @Dragon496 

You can try the following approach:

1.Firstly, review the data lineage view for each workspace to check the data flow from the source to the report.

For further details, please refer to:

Data lineage - Power BI | Microsoft Learn
 

2.Secondly, try using the following API to check whether the source of each semantic model belongs to a data flow.

GET https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/datasources

For more information, please refer to:

Datasets - Get Datasources In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Here are the links to your similar questions:
Solved: Check which reports are using a dataflow - Microsoft Fabric Community
 

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.

[Dragon496]

For some reason, I have been unable to use that API call to retrieve the data sources.

Let me explain. We have a power shell routine that downloads various fabric tenant activities/objects each day and then populate an on premise database. That way we build up a history of our tenant.

So for example I have been trying some scripts today.
The following script runs successfully and returns data:-
$rJSon = Invoke-PowerBIRestMethod -Url 'admin/Groups/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx6f7/datasets' -Method Get
$rJSon

However, the following script returns an error saying "dataset {guid} is not found
$xJSon = Invoke-PowerBIRestMethod -Url 'groups/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx6f7/datasets/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx306/datasources' -Method Get
$xJSon

I am somewhat confused, as I am supplying the same work group guid, that is successful in my first snippet above. Also, the dataset guid is also correct because I can see it either in my database or in the Json.

I am aware that the second API call does not start with "admin".

Do I need a different module for retrieving the data sources? Any advice?

Thanks

[Anonymous]

Hi, @Dragon496 

1.Firstly, based on your error message, we cannot rule out the possibility that there is an issue with your datasetId.

You can try opening the semantic model you need in the service and checking its URL:

The part highlighted in red above is the datasetId.

2.Secondly, ensure you are logged in within PowerShell:

Continue with your attempt. Below is a screenshot from my test:

Of course, if you have any new discoveries or questions, please feel free to get in touch with 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.