topic Getting error when connecting to SharePoint List in Desktop

Getting error when connecting to SharePoint List

arevach — Mon, 19 Sep 2016 11:42:02 GMT

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,

Re: Getting error when connecting to SharePoint List

Anonymous — Tue, 20 Sep 2016 08:54:33 GMT

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

Re: Getting error when connecting to SharePoint List

arevach — Sun, 25 Sep 2016 07:36:58 GMT

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?

Re: Getting error when connecting to SharePoint List

djnww — Sun, 25 Sep 2016 14:28:45 GMT

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