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.
Using Power BI Desktop Nov 2019 connecting to SharePoint Online list. I need to get list item versions, but tget this error when expanding the Versions column in the Query Editor:
DataSource.Error: We couldn't parse OData response result. Error: A value without a type name was found and no expected type is available. When the model is specified, each value in the payload must have a type which can be either specified in the payload, explicitly by the caller or implicitly inferred from the parent value.
Details:
DataSourceKind=SharePoint
DataSourcePath=https://<site url>
Solved! Go to Solution.
Hi @antwhite
To get SharePoint Online list item Versions, please refer to the similar thread:
Message (2,3,9) should be useful.
For the error, you could check the possible solution to this.
https://community.powerbi.com/t5/Desktop/project-online-custom-fields/m-p/688604#M331960
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @antwhite
To get SharePoint Online list item Versions, please refer to the similar thread:
Message (2,3,9) should be useful.
For the error, you could check the possible solution to this.
https://community.powerbi.com/t5/Desktop/project-online-custom-fields/m-p/688604#M331960
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks, a quick investigation showed that the Web.Contents/Xml.Tables approach looks like it will work - fair bit more M code to do however.
It would be good if the OData issue could be fixed...
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.