Forum Discussion

TePe's avatar
TePe
Helper IV
6 years ago

M function to read from api.powerbi.com

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). 
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi TePe ,

Which information you need to read from api.powerbi.com? Could you please provide more detail? Thank you.

Best Regards

Rena

      • TePe's avatar
        TePe
        Helper IV
        6 years ago

        Hi,

         

        I'm trying two different way...

         

        One is simply using the web source and using something like https://api.powerbi.com/v1.0/myorg/groups as a source. 

        The alternative is that I use a M script like this:

         

        (MyDomain as text) =>

        let

        Source = Json.Document(Web.Contents("https://api.powerbi.com/v1.0/" & MyDomain & "/admin/groups?$expand=users&$top=100")),
        value = Source[value],
        fnGetWorkspaceUsers = Table.FromList(value, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
        in fnGetWorkspaceUsers

         

        At the end it's boiling down to the question how to authenticate. "Organizational Account" gives me this message:

        Basic Authentcation returns:

         

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

         

        Thanks,

         

         

        Thomas