List of workspaces,scheduled datasets, dataflows etc.

[johnpjustus]

Hello All,

In our PowerBI service environment, we have workspaces (premium, premium capacity) , dataflows that refreshes on schedule, sematic models that refreshes on schedule, reports etc.,

Is there any report that has all this information?

Thanks,

John

[Anonymous · Accepted solution]

Hi @johnpjustus ,

As you mentioned, you can use rest api's to get the list of workspaces, data flow, report's etc.
As an example, I have used dataflow to get the information about dataflow by providing groupid through the following url:

GET https://api.powerbi.com/v1.0/myorg/groups/{groupId}/dataflows

Also, you can refer to below document:

Dataflows - Get Dataflows - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Workspaces - List - REST API (Azure Power BI Workspace Collections) | Microsoft Learn

Reports - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Best Regards,
Adamk Kong

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

[Greg_Deckler]

@johnpjustus Not a single report that I know of. You could use the Power BI Admin PowerShell Cmdlets to extract the data and create the report.

[johnpjustus]

Thanks for the response Greg. Thats so sad.

Let me look in to the API's..