Forum Discussion

TePe's avatar
TePe
Helper IV
6 years ago

OAUTH popup window error

Hi,   we're trying to load users from AAD into Power BI as described here: https://community.powerbi.com/t5/Desktop/Get-Data-Active-Directory/m-p/73792#M30680. This works fine with the Power BI Des...
Need Help
v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi TePe ,

 

What's the error message? You could provide a screenshot of the error or share the details of the error in text here.

 

  • TePe's avatar
    TePe
    Helper IV
    6 years ago

    Hi,

     

    sorry for the late feedback... The exact error message is: There was an error in the OAuth popup window (Session ID: xxxxxxx). You see the popup window for a fraction of a second before it goes away and you see the following message:

    Thanks,

     

     

    Thomas

    • v-eachen-msft's avatar
      v-eachen-msft
      Community Support
      6 years ago

      Hi TePe ,

       

      You could use "Basic" authentication instead of Organizational. Please check if it works.

       

      • TePe's avatar
        TePe
        Helper IV
        6 years ago

        Hi

         

        Just tried... It asks me "Please specifiy how to connect". There's the button with "configure connection" where I can choose between anonymus, basic and "organizational account" authentication. When I use basic I can go and provide my user in the format [email protected] and provide my password. But no matter if I provide a correct or incorrect login it just jumps back and asks "Please specify how to connect".

         

        Here's the M-Code I'm using.

         
        let
          Query = (MyDomain as text, MyGroup as text) =>
        let
            Source = Json.Document(Web.Contents("https://graph.windows.net/" & MyDomain & "/groups/" & MyGroup & "/members?api-version=1.6")),
            value = Source[value],
            fnGetGroupMember = Table.FromList(value, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
             in
            fnGetGroupMember
        in
          Query
         
        Yes, not elegant, but it works in Power BI Desktop. Parameters you need is a domain and the GUID of a group you have there...
         
        THANKS & Best Regards,
         
         
        Thomas