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

     

    • jimmy7377's avatar
      jimmy7377
      Frequent Visitor
      5 years ago

      HI Any resolution to this yet as i am having the same issues, I am trying to connect tot eh File on Sharepoint( Its in teams) and we have an org account that has set access to read all the information so dataflows is logged in as me. 

       

      There was an error in the OAuth popup window (Session ID:XXX)

      I try basic does not work.

       

      any other suggestions?

       

      thanking you in advance