topic Re: retrieve metadata sources SSAS in Developer

retrieve metadata sources SSAS

Anonymous — Wed, 09 Feb 2022 15:21:18 GMT

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...

Re: retrieve metadata sources SSAS

lbendlin — Fri, 11 Feb 2022 03:04:21 GMT

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.

Re: retrieve metadata sources SSAS

Anonymous — Fri, 11 Feb 2022 11:32:31 GMT

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?

Re: retrieve metadata sources SSAS

lbendlin — Fri, 11 Feb 2022 12:14:41 GMT

Are you on shared capacity or on Premium?

Re: retrieve metadata sources SSAS

V-lianl-msft — Mon, 14 Feb 2022 02:41:52 GMT

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.

Re: retrieve metadata sources SSAS

Anonymous — Wed, 16 Feb 2022 12:11:08 GMT

Not sure, I believe I am on premium.

Re: retrieve metadata sources SSAS

lbendlin — Wed, 16 Feb 2022 12:51:16 GMT

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