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