Getting error when connecting to SharePoint List

[arevach]

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,

[v-yuezhe-msft]

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]

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]

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