RScriptWrapper.R Permission denied

[Anonymous]

I would like to use the Query Editor's R script feature in order to export a csv of a table/query.  I get this error when I try to run any R script.  I've found little information on RScriptWrapper.R.  Any help would be appreciated.

I have the latest MS R open installed as well as Rstudio

[Daryl-Lynch-Bzy]

Hi, @Anonymous   I going to start by asking "Why"?

1. Power Query to export to Csv using R  -  not recommended Power Query should not be used to write data
2. Power BI Visual to export to Csv using R  - might be limited because this is using Microsoft R library not your library.
3. R to import from Power BI and the export to Csv - this is better option but required knowledge of the R.Olap connectors.

I would personally go for an easier option.  Use Power Query within Excel to export the data an Excel table.

Many thanks

Daryl

[Anonymous]

Thank you, Daryl.  I will look into other methods of extraction.  However, I still have the larger issue of not having access to Rscriptwrapper, which prevents any funtionality of using R within PowerBI, regardless of the 'why'.