cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lorenna Frequent Visitor
Frequent Visitor

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, 

 

2019_02_07_12_14_46_brands_Error_report_stock_Copy_Power_BI_Desktop.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Store/save matrix values with timestamp

@lorenna,

 

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 1
Community Support Team
Community Support Team

Re: Store/save matrix values with timestamp

@lorenna,

 

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.