retrieve metadata sources SSAS

[Anonymous]

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?

I saw this posted Admin - Datasets GetDatasourcesAsAdmin - REST API (Power BI Power BI REST APIs) | Microsoft Docs

I am not sure where exactly can i execute the GET command? Where inside https://app.powerbi.com/ can I execute that GET command?

My goal is just to get a dump of report and cube name that it consumes from...

[V-lianl-msft]

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.

[Anonymous]

It gets stucked in:

I have in another tab open app.powerbi.com

Perhaps I thought there is a way of executing it, but from the app.powerbi.com Edge tab?

[lbendlin]

Are you on shared capacity or on Premium?

[Anonymous]

Not sure, I believe I am on premium.

[lbendlin · Accepted solution]

You will want to know for sure. As @V-lianl-msft mentioned you need to have tenant admin rights for some of these queries.

[lbendlin]

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.