Forum Discussion
Issues connecting to sharepoint
Hi,
After the latest update, I am having problems connecting to a sharepoint library:
DataSource.Error: We couldn't parse OData response result. Error: The property 'SupplierNameId' does not exist on type 'Microsoft.SharePoint.DataService.DrawingMasterItem'. Make sure to only use property names that are defined by the type.
Details:
DataSourceKind=SharePoint
DataSourcePath=http://xxx
How can I resolve this?
/Ruth
I managed to solve my issue!
Here is what I did, I had a supplier name column that had type lookup that i changed to a type choice (created new one) and after that I got that error.
I recreated the lookup column, added it to my sharepoint library and voilá! It is working now :)
/Ruth
6 Replies
Is this a SharePoint list and what is the version? 2010, 2013, 2016, Online? Any info on how many data columns and types that you can provide? I can try to recreate the issue.
I managed to solve my issue!
Here is what I did, I had a supplier name column that had type lookup that i changed to a type choice (created new one) and after that I got that error.
I recreated the lookup column, added it to my sharepoint library and voilá! It is working now :)
/Ruth
Hi ruthpozuelo,
How did you get data from SharePoint Library? In Power BI desktop October update version or Power BI Service? Which data source did you use to get data? Please share more information for us to analyze the issue.
Best Regards,
Qiuyun YuHi v-qiuyu-msft
Yes of course,
I used Sharepoint.Contents to get the data using the Power BI desktop October update_
= SharePoint.Contents("http://xxxx)/", [ApiVersion = 14])
Unsure what you mean with "which data source", I am importing data from sharepoint 2010 using sharepoint.contents.
Does this help?
/Ruth
