cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vickyd
Helper V
Helper V

Unable to connect to Sharepoint List

I am trying to connect to a Sharpeoint List that I have access to but not able to get through. 

 

 

As suggested in a few posts I'm using the URL of the base site e.g. https://ops.portal.companyname.com. The site uses Azure single sign-on. However, I'm always getting the error below. 

Sharepoint Error.png

 

4 REPLIES 4
v-yulgu-msft
Microsoft
Microsoft

Hi @vickyd,

 

Were you using the OData connector or the SharePoint Online List connector?

 

What authentication type did you use, anonymous, Windows or Microsoft account? 

 

Such an connection error ("neither OData service or feed") can be caused by incorrect credentails. Please check whether you provided valid login account.

 

If you weren't prompted for a username/password it's possible you already had credentials stored. You could try deleting your credentials and connecting again.

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.


@v-yulgu-msft wrote:

Hi @vickyd,

 

Were you using the OData connector or the SharePoint Online List connector?

 

What authentication type did you use, anonymous, Windows or Microsoft account? 

 

Such an connection error ("neither OData service or feed") can be caused by incorrect credentails. Please check whether you provided valid login account.

 

If you weren't prompted for a username/password it's possible you already had credentials stored. You could try deleting your credentials and connecting again.

 

Best regards,

Yuliana Gu


Sharepoint List is what I am using. 

Our Sharepoint site uses Azure AD authentication so typically we enter our login credentials in the browser. I used Windows Authentication i.e. "Use my current credentials" as well as "Use alternate credentials" in Power BI. Both are giving same error.

 

I deleted Windows credentials from Credential Manager and also deleted any stored connections in the Data Source settings in Power BI.  No luck. 

 

Note: I don't have access to the base sharepoint site. I only ahve access to a sub-site under the base company sharepoint portal. However, I did try entering base site URL as well as the sub-site URL. Same error for both. 

Hi @vickyd,

 

Currently, Power BI desktop doesn't support Azure AD authentication.

 

You could upvote this idea or add your own comments under the idea.

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

problem sharepoint lists 2010 with power bi desktop, we are stopped and we can not move forward, I have many customers with sharepoint 2010 and I can not attend them, who can help me please

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.