How to create a historical table with data from a daily table

[Emilio_Marin]

Hello.

I have a database that shows only data for today. is there a way to create a historical table with "snapshots" of this daily table?

So I can have a historical table to use.

Thanks.

[jdbuchanan71 · Accepted solution]

Not in PowerBI, no.  You would do that sort of work on the database side with a stored procedure that copies the daily table into a running historical table every day using a scheduled job.  Then your model would pull from the historical table.

[Anonymous · Accepted solution]

Hi @Emilio_Marin ,

If your database supports it, creating a clone of your daily table can be an efficient way to capture a snapshot without affecting the production environment. This method is particularly useful for databases that support zero-copy cloning, minimizing storage costs and ensuring data integrity. For more details on table cloning, please refer to this documentation on cloning tables.

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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

[jdbuchanan71 · Accepted solution]

Not in PowerBI, no.  You would do that sort of work on the database side with a stored procedure that copies the daily table into a running historical table every day using a scheduled job.  Then your model would pull from the historical table.

[lbendlin]

Power BI has no memory* . You need to manage your snapshots in the upstream system.

* Yes, there is the self referencing option but that has no safety net.