Forum Discussion
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,
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?
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
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