Showing results for 
Search instead for 
Did you mean: 
New Member

Archiving historical data with Power BI

We'd like to have a historical weekly view of the status of our clubs. The problem is that the status is stored in a column and it changes over time. When the status changes (a new status overwriting an old status), we lose historical data. We're wondering if we can archive weekly snapshots in a separate table. Feels like a trivial task... but can't find a way to do it with Power BI. Does any of you know how to do it?

Solution Sage
Solution Sage

Re: Archiving historical data with Power BI

Frequent Visitor

Re: Archiving historical data with Power BI

How did this end up working out for you?  I'm currently encountering a similar issue with a report that I manage on a weekly basis.  I have static fields that can change week-over-week and I need to track those trends.  Currently, I am doing this manually by archiving excel spreadsheets and time stamping each line item.

Helpful resources


Microsoft Ignite

This will be a conference that you do not want to miss!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors