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
Anonymous's avatar
Anonymous
Not applicable
5 years ago

vpatel55 

 

You can not use the same URL with Odata. If you want to connect to a specific online list, you can use  the OData URL like following format: https://yoursharepointsite/_vti_bin/listdata.svc/ListName. 

 


Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

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.