DataSource.Error accessing SharePoint Online list item Versions

[antwhite]

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>

[v-juanli-msft · Accepted solution]

Hi @antwhite 

To get SharePoint Online list item Versions, please refer to the similar thread:

https://community.powerbi.com/t5/Desktop/Getting-SharePoint-List-items-with-full-history-version/td-...

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.

[antwhite]

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...