📊Power BI: SharePoint List Item Version History

In this video, we will see how we can bring the Version History of our SharePoint List Items from SharePoint into Power BI.

To achieve that, first, we will connect to our SharePoint List. Then we will eliminate all the columns we do not need and keep only the ones we need. After having prepared our table we are going to use a custom query to invoke the Version History data from SharePoint into each and one of our item rows in the main table.

The code for the Query Invoke can be found here since I cannot paste the code in the description due to character limits on YouTube video descriptions: https://community.fabric.microsoft.co...

After that, we are going to invoke a custom function in our main table and use the query that we just created to call the SharePoint API and pass the information from each row into the API call to retrieve the version history for each row.

Enjoy!

0:00 Introduction to the topic of the video
0:50 Introduction to the data source of the demo and the problem
1:40 Showcasing how the result looks like
2:13 Connecting to the data source
3:15 Cleaning, formatting, and transforming the data
6:35 Creating the new custom query
7:00 Explaining the custom query M code
8:37 Invoke a Custom Function
9:36 Transforming the data from the custom function
13:55 Comparing the result with the one on SharePoint
15:12 Talking about working with complex/table-type columns
16:40 Conclusion and closing

If you want to learn more about Power BI, you are welcome to follow the channel and subscribe to the Power BI playlist here:
   • Power Automate & SharePoint Online - ...  

Feel Free to follow me on other social media platforms as well:
https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj