M function to read from api.powerbi.com

Question

I'd like to create a M function which reads from api.powerbi.com. Any idea how to authenticate with this data source? I had no luck with basic (didn't work) and Organizational (not supported).&nbsp;

anonymous · Answer

Hi&nbsp;TePe&nbsp;,Which information you need to read from api.powerbi.com? Could you please provide more detail? Thank you.Best RegardsRena

tepe · Answer

Hi,&nbsp;I need the list of workspaces with their users... So I wanted to use this API:&nbsp;&nbsp;https://api.powerbi.com/v1.0/myorg/admin/groups?$expand=users&amp;$top=100&nbsp;I tried it via M code and the Web data source, but how to authenticate?&nbsp;Thanks,&nbsp;&nbsp;Thomas

anonymous · Answer

Hi&nbsp;TePe&nbsp;,How did you connect to that API? And whether you get any error when connected? If yes, could you please provide the related screen shot?In addition, please check if the following blogs can help you.how to connect my web api wtih Power BI Reports?Why is it so complex to connect to an API with Power BI or Power Query? The OAuth explainedAPI Strategies with Power BIACCESS TO THE RESOURCE IS FORBIDDEN ON POWER BI DESKTOPBest RegardsRena

tepe · Answer

Hi,&nbsp;I'm trying two different way...&nbsp;One is simply using the web source and using something like&nbsp;https://api.powerbi.com/v1.0/myorg/groups as a source.&nbsp;The alternative is that I use a M script like this:&nbsp;(MyDomain as text) =&gt;letSource = Json.Document(Web.Contents("https://api.powerbi.com/v1.0/" &amp; MyDomain &amp; "/admin/groups?$expand=users&amp;$top=100")),value = Source[value],fnGetWorkspaceUsers = Table.FromList(value, Splitter.SplitByNothing(), null, null, ExtraValues.Error)in fnGetWorkspaceUsers&nbsp;At the end it's boiling down to the question how to authenticate. "Organizational Account" gives me this message:Basic Authentcation returns:&nbsp;If it's true about what I found out that the only chance is to use a customer connector for that, this would be really bad because I don't have access to AAD in the organization and deploying a custom connector would be a hell to go through security reviews. I just want to get something I can see on the portal in Power BI! Nothing fancy! Funny enough it works with the Graph API, so I can find out AAD users and groups...&nbsp;&nbsp;Thanks,&nbsp;&nbsp;Thomas

Forum Discussion

M function to read from api.powerbi.com

4 Replies

Related content

pbiazure://api.powerbi.com Excel Connection

cannot connect to api.powerbi.com

Power BI read aloud

Gen2 dataflow read only mode issue

DAX Studio space after function name