Use historical data from a Sharepoint list in PowerBI

[Anonymous]

Hey everyone! 

I am trying to set up an report to show the historical development of a project (similar to this one: https://blog.pragmaticworks.com/power-bi-custom-visuals-impact-bubble-chart#:~:text=The%20Impact%20B...). 

I am getting the data from a Sharepoint list and whenever a change in the Sharepoint list is made I would lke to get the new value with a timestamp into PowerBI without overwriting the old one, so I can show the historical development in the bubble chart.

Is this possiblie at all? I have been looking at this solution: https://community.powerbi.com/t5/Desktop/Storing-and-using-information-from-a-dynamic-data-source-us...

but been struggling with the implementation. I was told this should be possible using Power Automate, but also here I wasn't successful. 

I'd really apprecciate your help, thank you in advance! 

[amitchandak]

@Anonymous , refer if the DAX append approach discussed in these blogs can help

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/

[Anonymous]

Hi @amitchandak , thank you for your answer. 

I had a look at those posts, but am not sure if they are solving my problem. I am fairly new to PowerBI so that might be part of the issue.

The Sharepoint list is build as: 

Project1

Data_Project1_1

Data_Project1_2

Data 1 and Data2 are expected to change over time, so whenever they change their value will be updated and overwritten in the Sharepoint list. 

So we get: 

Project1

Data_Project1_new_1

Data_Project1_new_2

Etc. 

In PowerBI I would like to show this development in the impact bubble chart, so I need the date of where Data was entered and Data2 and so on. 

I hope my explanation makes sense. 

Thank you again!