Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 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.
What can I do?
Thanks,
Thomas
I'm trying to get information from SharePoint, so you don't need to use a gateway for that. In my case, I use the gateway to get the information from the on-premises server as well. The important thing is that after you specify None for the gateway field and leave the authentication type as your organization account, everything will run fine.
J Wick
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.
THIS WORKS!
I use Dataflows with Power BI and Odata feed connections and no other solution works except this one, thanks!
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.
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
Hi @TePe ,
You could use "Basic" authentication instead of Organizational. Please check if it works.
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 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".
Here's the M-Code I'm using.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.