Forum Discussion
retrieve metadata sources SSAS
I have several workspaces with reports, datasets, etc in my https://app.powerbi.com/home
Most of the reports consume from a SSAS like this:
Is there a way to write some sort of query in https://app.powerbi.com/home and retrieve all cubes used on every report?
Hi Anonymous
Yes this can be done, what you would need to do is to use the Power BI APIs to get a list of datasets in each workspace and then use this API below to get the data sources
Admin - Datasets GetDatasourcesAsAdmin - REST API (Power BI Power BI REST APIs) | Microsoft Docs
Another option is to use the Power BI Scanner, here is a great blog post on how to configure it and get it working: Using the Power BI Scanner API to Manage Tenant's Entire Metadata -
1 Reply
Hi Anonymous
Yes this can be done, what you would need to do is to use the Power BI APIs to get a list of datasets in each workspace and then use this API below to get the data sources
Admin - Datasets GetDatasourcesAsAdmin - REST API (Power BI Power BI REST APIs) | Microsoft Docs
Another option is to use the Power BI Scanner, here is a great blog post on how to configure it and get it working: Using the Power BI Scanner API to Manage Tenant's Entire Metadata -