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

3 Replies

  • 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