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

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.

Reply
Anonymous
Not applicable

Dataflows - There was an error in the OAuth popup window

I've been trying to utilise dataflows in Power BI but when connecting to SharePoint on-premise using the odata i'm getting no luck.

 

Mostly common errors are for OData:

1. There was an error in the OAuth popup window

  1a. This is when connecting to root level to an externally hosted odata connection point of the on-premise SharePoint solution such as https://sharepointsite.com/_vti_bin/listdata.svc and see below for connection 

Logical_0-1657288828160.png

 

    1b. I'll also try multiple ways such as using "none" for the data gateway  and using "Organizational account" for the "Authentication Kind" but still the same error stated above.
    2. I'll also try using Basic auth and this just returns this:

Logical_1-1657288993115.png

 

Ive also tried to connect directly to Odata on the power bi desktop editor and it works fine with the .svc link stated above.

 

Any ideas?

 

1 ACCEPTED SOLUTION
v-mengzhu-msft
Community Support
Community Support

Hi @Anonymous ,

 

For your first error, through research, I found out that the reason that the popup was not working is because there was an erroneous space or some other wrongs in the URL.  It appears the error merely indicates that the connection is not possible so I would advise a detailed check of your connection definition. 

 

At the same time, your second error also clearly indicates that there is a problem with the URL you provided.

 

So I check your URL and find something wrong, this is the correct format for URL entered:

vmengzhumsft_0-1657523756630.png

 

Power BI: Two Way To Get Data From SharePoint List / Library - TechNet Articles - United States (English) - TechNet Wiki (microsoft.com)

 

So check this part  you entered,

vmengzhumsft_1-1657523756632.png

This is the URL I test:

vmengzhumsft_2-1657523756632.png,you can refer to it.

 

Best regards,

Community Support Team Selina zhu

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

View solution in original post

1 REPLY 1
v-mengzhu-msft
Community Support
Community Support

Hi @Anonymous ,

 

For your first error, through research, I found out that the reason that the popup was not working is because there was an erroneous space or some other wrongs in the URL.  It appears the error merely indicates that the connection is not possible so I would advise a detailed check of your connection definition. 

 

At the same time, your second error also clearly indicates that there is a problem with the URL you provided.

 

So I check your URL and find something wrong, this is the correct format for URL entered:

vmengzhumsft_0-1657523756630.png

 

Power BI: Two Way To Get Data From SharePoint List / Library - TechNet Articles - United States (English) - TechNet Wiki (microsoft.com)

 

So check this part  you entered,

vmengzhumsft_1-1657523756632.png

This is the URL I test:

vmengzhumsft_2-1657523756632.png,you can refer to it.

 

Best regards,

Community Support Team Selina zhu

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors