Forum Discussion

vpatel55's avatar
vpatel55
Kudo Commander
5 years ago

Cannot access SharePoint data source

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 ...
Need Help
vpatel55's avatar
vpatel55
Kudo Commander
5 years ago

Hi Anonymous this has not worked, but it has provided some clues. I'm hoping these clues will be useful for you to help me find the issue.

 

My list is called "Reimbursements". If I use the same URL format:

 

I get the following error:

However, this list definitely exists:

 

But If I use the list name "SharePointHomeOrgLinks", which appears to be a system list (and which also appears when I use the SharePoint connector), then I can see the list with no issues:

 

 

So its like I'm being denied permission to see my custom lists - even though I can clearly see them through the web interface?

 

Thanks and I look forward to your comments.

 

Watsky's avatar
Watsky
Solution Sage
5 years ago

vpatel55 what if you tried it like this:

 

sharepoint.com/_api/web/lists/Reimbursements

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.