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.
Hi Anonymous
You can also use DAX Studio or R for exporting the data to excel.
I can test the output if provided the sample file.
Could you give a practical example of how I could do this through DAX or R?
And how can I pass the data on to you?
You can upload your sample file to onedrive or google drive and provide me the link.
I would like to see that whether the exact issue can be reproduced.
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.