Forum Discussion
R Visual Script Auto Run to save historical data
Hi cmsouth ,
According to my testing, the R visual scripts do not run automatically when the dataset is refreshed, so you cannot achieve automatic saving of historical data of visuals. It is recommended that you use M instead of DAX to calculate the final result and then use R scripts in Power Query to store the historical data.
Or you can use the Report Builder to connect to the datasets on the Service, then create paginated reports and subscribe to them.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
As mentioned, I want to save report data after it is refreshed so i can report on historical results - i want to trend $/Counts/etc on summary data. For example, I have created a formula that calculates what stage an order is in and another that summarizes how many orders are in that stage TODAY. I want to report if we are getting fewer or more orders in that stage.
I have a few DAX formulas that I've created in my data that are used in the report/ visual, so i want to save that data after the refresh (I save it now using R-Script back to a MySQL table by date). Then i can pull that historical in and create a bar chart by date.
I would like to leverage the formulas already created, but am option to other methods to accomplish my objective....
Power BI is not the right tool for that. It has no memory. Use a different process to capture your historical snapshots.