Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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...