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 ,

 

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