Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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)
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
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)
User | Count |
---|---|
94 | |
86 | |
78 | |
69 | |
63 |
User | Count |
---|---|
114 | |
99 | |
97 | |
65 | |
59 |