Track changes from Excel to Power Bi

[Mic1979]

Hello,

here I have this problem.

I have an excel sheet with values that can change over the time.

When I refresh the excel sheet, the old values are overwritten and so I get them lost.

I was looking for a way to have a table with the old values stored.

What I would not do is to make this process manual, in other words I would like to keep track of changes automatically.

Not sure is power bi is the right tool to do this.

Thanks in advance for your answer.

[Ritaf1983 · Accepted solution]

Hi @Mic1979 
You can use a power automate for this goal.
Take a look at the linked tutorials:

https://www.youtube.com/watch?v=8KyF-wMP0O4

https://www.youtube.com/watch?v=SOQeNnSwp60

 If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Mic1979]

Thanks a lot

[Ritaf1983]

Happy to help 🙂