Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Not applicable

Dataflow SharePoint There was an error in the OAuth popup window

I'm trying to open Excel Files from SharePoint, by first connecting with SharePoint.Files( ) to my SharePoint directory (This part works OK), then filtering the file and opening it with the method:

Excel.Workbook(Table.SelectRows(Source, each [Name] = "My File Name.xlsx"){0}[Content])

But o this step, I get the "Please specify how to connect" notice, and when I try to login with my Organizational Account, I get over and over the same error:
"There was an error in the OAuth popup window (Session ID: ##############)"
I have tried on Edge and Chrome and still get the same...

Community Support
Community Support

Hi @Anonymous ,

What the Authentication kind do you use?  I viewed a similar thread. It worked fine when the user changed the authentication from "Organizational" to "Basic". Maybe you could have a try. 


Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Not applicable

I cannot do that, once the only available options are Microsoft Account and Anonymous. I tried logging out and in again, and three different browsers, and no luck.



Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.