Dataflow SharePoint There was an error in the OAuth popup window

[Anonymous]

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

[v-xuding-msft]

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.

https://community.powerbi.com/t5/Desktop/There-was-an-error-in-the-OAuth-popup-window/td-p/640433 

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.

[Anonymous]

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.