The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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
@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-Versions/td-p/859761
________________________
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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group