Return Values from R calculations; practically anything except R visuals

[ahussnain]

Hi, I want to use R to do the forecasting. So I load the R script and it can create a visualization.

But I want to get the forecasted values for things like calculating the forecast accuracy (compare against the actual values), and for some other calcs too.

Is there a way to read R values and use them in the DAX measures? Any ideas? 

[v-huizhn-msft]

Hi @ahussnain,

After research, we can't get the value from R visualization directly. But you can try to export data by click the ellipsis(...) on the top right of your R visual->export data to a csv file(please see the highlighted in following screenshot). And check if the csv file includes your wanted data, then get gata from the csv file and use it in measure.



Best Regards,
Angelia

[v-huizhn-msft]

Hi @ahussnain,

Have you resolved your issue? Please mark the right/helpful reply as answer, and we appreciate you share your own workaround, more members will benefit from here.

Best Regards,
Angelia