Creating “ snapshots ” of data in Power BI

[railtons]

Hello team,

I apologize for the level of the question if it doesn't make any sense, because I don't know the details of Power BI.

Well, I have a report here that manages projects and in it there are some numbers that are tracked, for example the number of days planned (this information comes directly from my backlog in azure devops), another field is the remaining to be done that also comes from the backlog.
The idea is that the planned days field is not changed, what should be adjusted is always the remaining to be done.
However, some users don't understand very well and end up changing the information in the backlog of planned days, so when an update is made in Power BI this information will also be updated.

So my question is, is there any way within power bi, or with the integrated use of power automate, that I can create a snapshot each month of all my power bi data so that I can consult those “snapshots”?

Thanks

Railton

[Anonymous · Accepted solution]

Hi @railtons ,

Thanks for the reply from johnt75 .

You can set up a report subscription in Power BI Service to automatically email snapshot data each month.

For more information on using email subscriptions for reports and dashboards in Power BI Service see the official documentation below:

Email subscriptions for reports and dashboards in the Power BI service - Power BI | Microsoft Learn

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[johnt75]

It can't be done directly in Power BI, but you could create something in Power Automate which executes a query, or queries, against your semantic model and writes that data to a CSV or something. Then Power BI would read from the existing data source and the CSV and combine the data.