Cannot access SharePoint data source

Question

I am trying to connect Power BI to a SharePoint list. I can access the list through the SharePoint online site with no issues.

But when using the SharePoint connector, my list is not shown. When I try through the ODATA feed, it states that "We couldn't authenticate with the credentials provided", even though I have no issues with the credentials (and can access Excel files on the SharePoint site with no issues with the same credentials). I have tried both the root directory, and with subfolders only, with the same issue. I have also tried to change https to http, and the issue still persists.

Any help would be appreciated.

Thanks.

imkef · Answer

try clicking on "Sign in as different user" and provide your credentials again.
It very much looks like an authentication problem.Also make sure to authenticate at the highest level possible.
&nbsp;

vpatel55 · Answer

Thanks for the response&nbsp;ImkeF&nbsp;. Tried that, but same issue. It says that I'm signed in, but once I click connect, it says that it can't authenticate with the details provided - even though I am signed in:&nbsp;&nbsp;

watsky · Answer

vpatel55&nbsp;have you tried clearing permissions on the data source then signing back in?&nbsp;&nbsp;Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up! ?Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.

vpatel55 · Answer

Hi Watsky&nbsp;yes I have tried clearing the permissions and signing back in. I can sign in with no issues, but it still says "We couldn't authenticate with your credentials" - even though it says right next to this "You are signed in". I'm thinking this must be a bug, but it would be good to get your thoughts.&nbsp;&nbsp;

anonymous · Answer

vpatel55&nbsp;
&nbsp;
You can not use the same URL with Odata.&nbsp;If you want to connect to a specific online list, you can use&nbsp; the OData URL like following format:&nbsp;https://yoursharepointsite/_vti_bin/listdata.svc/ListName.&nbsp;
&nbsp;
Paul Zheng _ Community Support TeamIf this post helps, please Accept it as the solution to help the other members find it more quickly.