Forum Discussion

arevach's avatar
arevach
Regular Visitor
9 years ago

Getting error when connecting to SharePoint List

Hi, I have a  SharePoint list with json implemented inside. when i try to connect  it  to the Power BI for desktop and receive the following error:   Any thoughts? Thanks a lot,
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi arevach,

Could you please elaborate more details about that SharePoint list with json implemented inside? And how do you connect to SharePoint list in Power BI Desktop?

If you want to retrieve json object from a SharePoint list and import it into Power BI Desktop, you can connect to it using URL like http://yoursite/_api/web/lists/GetByTitle('ListName') via Get Data>Web entry. There is an example for your reference.




Thanks,
Lydia Zhang

  • arevach's avatar
    arevach
    Regular Visitor
    9 years ago

    Hi Lydia,

    My mistake. this is a plain list with no JSON. when i try to connect to it, i get the error. It does have complex data type such as people picker, lookup value but it's all OOTB columns.

    Any thoughts?

    • djnww's avatar
      djnww
      Impactful Individual
      9 years ago
      Hey,

      1. There are 2 sharepoint connectors. Make sure you've selected 'Sharepoint List' and not the other 'Sharepoint' connector. The error you have is usually due to the wrong connector being chosen.
      2. Can you please supply the string for the list that you used in PowerBI ? This is just to make sure that you have enteted it correctly.

      Cheers,
      D