Forum Discussion
Store/save matrix values with timestamp
Hi,
The data source is overwritten daily. I would like to store matrix results (computed with different measures) weekly in order to keep track of some KPI’s, to analyze their evolution from a historical perspective.
I am now saving the results in a manual way by exporting the data from the table but this is quite impractical, so I’d like to know if there’s a way to automatize it please?
Thanks in advance,
Anonymous,
I'm afraid export data to excel/csv can only be implemented manually. As a workaround, you can subsribe the report or dashboard, all subscriptions that have the frequency set to After data refresh will only send an email after the first scheduled refresh on that day.
Reference: https://docs.microsoft.com/en-us/power-bi/consumer/end-user-subscribe.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Anonymous,
I'm afraid export data to excel/csv can only be implemented manually. As a workaround, you can subsribe the report or dashboard, all subscriptions that have the frequency set to After data refresh will only send an email after the first scheduled refresh on that day.
Reference: https://docs.microsoft.com/en-us/power-bi/consumer/end-user-subscribe.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.