Creating and storing snapshots of a table in the data model

[Matt_HD]

Hi

I have a pbix file that pulls data from a couple of sources and brings together a mart table that i create a number of measures and visuals from.

I'd like to track this over time and the transactional data doesnt support this. 

My idea is to create a snapshot of this table daily (ie freeze it in time with a datestamp on each row) and store it in a snapshot table, the following day/week/period etc the model would create another snapshot and add it to the snapshot table and repeat ad infinitum.

Is this possible in the data model? if so does anyone have any examples or ideas please?

(Ive had a team previously do this for me in sql in a data warehouse in a previous life but the company im working for at the moment are very resource light so its only a PowerBI model in the service at the moment)

[jdbuchanan71]

@Matt_HD 

No, there is no warehousing capability in Power BI.  You would have to save the backups on the source side like you describe from your previous job.