Error in exporting data from power bi to csv file using R

[Anonymous]

I am trying to export data from power bi to csv file using R

I am giving the below command

write.csv(ALL_Data, "C:\\Users\\username\\Documents\\folder 1\\folder 2\\folder 3\\folder 4\\filename.csv")

I am getting the below error please help

DataSource.Error: ADO.NET: R script error.
Error in is.data.frame(x) : object 'ALL_Data' not found
Calls: write.csv ... eval.parent -> eval -> eval -> write.table -> is.data.frame
Execution halted

Details:
    DataSourceKind=R
    DataSourcePath=R
    Message=R script error.
Error in is.data.frame(x) : object 'ALL_Data' not found
Calls: write.csv ... eval.parent -> eval -> eval -> write.table -> is.data.frame

[v-diye-msft]

Hi @Anonymous 

You might refer to these similar posts:

https://community.powerbi.com/t5/Desktop/Error-when-Exporting-data-Using-R-Script/m-p/70156 

https://community.powerbi.com/t5/Service/Error-while-exporting-data-in-csv-file-using-R-script-in-power/m-p/739320 

[JirkaZ · Accepted solution]

Please see here: https://mitchellpearson.com/2018/07/15/quick-tips-export-data-from-power-bi-using-r/

the data is held in 'dataset' (not in ALL_Data)

[Anonymous]

Thanks @JirkaZ, it solved the issue