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?
You will want to know for sure. As V-lianl-msft mentioned you need to have tenant admin rights for some of these queries.
6 Replies
Did you notice the green "try it" button on the link you provided? Click that one, sign in, and then provide the dataset id for the dataset you want to dump the queries from.
Are you on shared capacity or on Premium?
Hi Anonymous ,
Please make sure The user must have administrator rights (such as Office 365 Global Administrator or Power BI Service Administrator) or authenticate using a service principal.
If you don't have this permission, you can try to use this API:https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/get-datasources-in-group
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
