Forum Discussion

cmsouth's avatar
cmsouth
Frequent Visitor
4 years ago
Solved

R Visual Script Auto Run to save historical data

I've created an R script in a Visual to summarize some key data and save it each day, for trend reporting.  I used the R Script on a Visual approach instead of an R script in a query because i have c...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    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.

cmsouth's avatar
cmsouth
Frequent Visitor
4 years ago

What a horrible answer.  I'll look elsewhere....

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    4 years ago

    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.