OAUTH popup window error

Question

Hi,&nbsp;we're trying to load users from AAD into Power BI as described here:&nbsp;https://community.powerbi.com/t5/Desktop/Get-Data-Active-Directory/m-p/73792#M30680. This works fine with the Power BI Desktop. If I now try to move the same code to Data Flows I need to use an Organizational Account here as well. So the OAUTH window pops up and closes within a fraction of a second presenting the message that an error happened.&nbsp;&nbsp;What can I do?&nbsp;Thanks,&nbsp;&nbsp;Thomas

huntingtonog · Answer

I was able to fix this by eliminating the last two parts of my url... "/sites/data" and retrying with Data Gateway: None and Organizational selected.

The popup persisted instead of going away, I was able to sign in on the organizational account, then I was able to go back and add the "/sites/data" on my sharepoint folder URL and have it go through correctly.

v-eachen-msft · Answer

Hi&nbsp;TePe&nbsp;,
&nbsp;
What's the error message? You could provide a screenshot of the error or share the details of the error in text here.
&nbsp;

tepe · Answer

Hi,&nbsp;sorry for the late feedback... The exact error message is:&nbsp;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,&nbsp;&nbsp;Thomas

v-eachen-msft · Answer

Hi&nbsp;TePe&nbsp;,
&nbsp;
You could use "Basic" authentication instead of Organizational. Please check if it works.
&nbsp;

tepe · Answer

Hi&nbsp;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 user@domain.com 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".&nbsp;Here's the M-Code I'm using.&nbsp;let&nbsp;&nbsp;Query&nbsp;=&nbsp;(MyDomain&nbsp;as&nbsp;text,&nbsp;MyGroup&nbsp;as&nbsp;text)&nbsp;=&gt;let&nbsp; &nbsp; Source&nbsp;=&nbsp;Json.Document(Web.Contents("https://graph.windows.net/"&nbsp;&amp;&nbsp;MyDomain&nbsp;&amp;&nbsp;"/groups/"&nbsp;&amp;&nbsp;MyGroup&nbsp;&amp;&nbsp;"/members?api-version=1.6")),&nbsp;&nbsp;&nbsp;&nbsp;value&nbsp;=&nbsp;Source[value],&nbsp;&nbsp;&nbsp;&nbsp;fnGetGroupMember&nbsp;=&nbsp;Table.FromList(value,&nbsp;Splitter.SplitByNothing(),&nbsp;null,&nbsp;null,&nbsp;ExtraValues.Error)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;in&nbsp; &nbsp; fnGetGroupMemberin&nbsp;&nbsp;Query&nbsp;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...&nbsp;THANKS &amp; Best Regards,&nbsp;&nbsp;Thomas&nbsp;

Forum Discussion

OAUTH popup window error

8 Replies

Related content

conditional formatting: popup window: bugs

There was an error in the OAuth popup window

Semantic Model - edit tables popup window disappear

There was an error in the OAuth popup window

There was an error in the OAuth popup window