Load the version history of a sharepoint list

[LParker97]

Hi for a project with a colleague we are wondering how you load the entire audit trail/version history of the data from a sharepoint list

to clarify Im asking for every ID, not just a single one.

thanks

[DataZoe]

@LParker97 did you see this thread? https://community.powerbi.com/t5/Desktop/Getting-SharePoint-List-items-with-full-history-version/td-... I think that's what you're trying to do.

[UAV-Test-Pilot]

@LParker97  How would you like this infromation diplayed

For example, If I have a list with the following items

ID	ITEM
1	Apple
2	Bannana

... And I update it to

ID	ITEM
1	Apples
2	Bannanas

How would you want this information displayed, in your end result? Do you want them to all appear in one giant flat file (see example below)? What version of sharepoint are you using: SharePoint online or on-premise?

ID	ITEM	Version
1	Apple	1
1	Apples	2
2	Bannana	1
2	Bannanas	2

If this helped, I would appreciate a Kudos!
If this resolves the issue, please mark it as a Solution! 🙂