Retrieving All Power BI Reports with Dataflow Connections in a Fabric Workspace Using Power BI APIs

[bexy]

#########################################################

groupId = '1234csdfv-dfgg24-cfgr-fdutrcncn7r684n7'

response = requests.get(url = f"https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/upstreamDataflows", headers = headers)

reports = response.json()

#########################################################

Using the Power BI APIs, I am attempting to retrieve the datasets and their dependent dataflows in a Fabric workspace. However, the output only includes details for a single report, such as its corresponding datasetObjectId, dataflowObjectId, and workspaceId, instead of listing all Power BI reports with Dataflow connections in the specified workspace.

Here is Microsoft official doc link I followed : https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-dataset-to-dataflows-links-in-group

Please assist me in resolving this issue.

[Anonymous · Accepted solution]

Hi @bexy ,

After doing the above based on your operations, you also need to use the following API to get the report:

Admin - WorkspaceInfo GetScanResult - REST API (Power BI Power BI REST APIs) | Microsoft Learn
After obtaining all the reports for the workspace, filter the API with the semantic model ID that you have filtered to meet the conditions, and finally use the semantic model ID to create the report.

Best Regards,

Ada Wang

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