Issues connecting to sharepoint

[ruthpozuelo]

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

[v-qiuyu-msft]

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 Yu

[ruthpozuelo]

Hi @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

[Greg_Deckler]

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.

[ruthpozuelo]

Hi @Greg_Deckler,

Sharepoint 2010. I get the error in the navigation step already...

/Ruth

[ruthpozuelo · Accepted solution]

Hi @v-qiuyu-msft, @Greg_Deckler

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

[Greg_Deckler]

Cool, glad you got that resolved! That's a weird issue!