Forum Discussion
Periodically store indicator values
Hello! I am in this scenario: I have data tables concerning a set of projects, coming from different databases. The data always refer to the current value: for example, the value of the "actual ...
Hi Anonymous
There have been other posts related to this (search for snapshot). Unfortunately, this is not currently supported in Power BI as the data that gets loaded is what is in the source. The only workaround I can think of is create a monthly snapshopt of my data or by using R (refer to this link https://community.powerbi.com/t5/Service/auto-export-of-data/m-p/127222#M19420)
Hi danextian,
Perhaps there is a way to memorize at least the values of the indicators every month, without saving the entire data set?
Thanks for your help.
You may try putting a table containing your indicators to a page and then use the export feature. Just hide the page so it won't be visible from your users.