Forum Discussion
Problem when exporting data to excel
Select R visual and Drag all the columns require in exporting data to the Values field . This will create a data frame called Dataset.
As You can see in the screenshot, I have written R script.
write.table.........
Change the path of the file to your desktop.C;/Users.........
and Execute the script by pressing play button.
You will see the R file exported to your desktop.
Alternatively, you can use write.csv method as well which I have commented here. This will save your file in the default R directory. However, You can change the file path to save it on Desktop.
Do you need to extract the data in .xls or the data in its source in Power BI?
I would like to get both .xls file data source as well as powerbi file.
This way I can test all three methods.
Hi Anonymous
Sorry to get back you late. I have tried in Excel 2016 and R Environment both to export the data.
Excel 2016 comes with the predefined currency format but Export in R is clean and without any format.
If you would like to proceed using R, You need to install R Environment on your machine.
I think this would be the most easy technique to export the data.
You can find the file at
https://drive.google.com/file/d/0B26iWnIZh6PSV0gzMXBveFZNN1E/view?usp=sharing
Thanks, but how do I use R on power BI? How will I export using R? I already have R installed on my machine.