Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
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
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.
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
Cool, glad you got that resolved! That's a weird issue!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.