File edit History - Power Query

[Anonymous]

Hi everyone, 

I am using sharepoint with some online document (Excel). I would like to extract the full list of edit for a specific file. 

I have been trying to use the command

SharePoint.Content().

When I want to "Extract" the version history table with power query, I get this error. 

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.

Does anyone have face this issue? 

Regards

[Anonymous]

Hi @Anonymous,

I'd like to suggest you take a look at the following link that mentioned similar requirements:

Getting SharePoint List items with full history version? 

Regards,

Xiaoxin Sheng

[Fowmy]

@Anonymous 

Can you refer to this thread, you may find some guidance here: https://community.powerbi.com/t5/Power-Query/DataSource-Error-accessing-SharePoint-Online-list-item-...

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube, LinkedIn