Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
I’m trying to export data from Power BI using R. I’ve tried to follow http://www.thebiccountant.com/2015/12/28/how-to-export-data-from-power-bi-and-power-query/
However I’m getting an error message:
The steps that I’ve used:
1. Create new report (page1)
2. Choosing two columns (BLNumber, ChrgWeight) from table (PS_total)
3. Applying R script visual
4. Getting the R script editor
5. Pasting this code: write.table(trim(dataset), file=”Libraries/Documents/R-test.txt”, sep = “\t”, row.names = FALSE);
6. When pressing the Run script, I’m getting the Error message and file R-test.txt is still blank
Can anyone please help me?
Thanks
As I tested, you need to grant the permisson for "ALL APPLICATION PACKAGES" and "ALL RESTRICTED APPLICATION PACKAGES" on that text file security.
Then that R script should work.
require(gdata) write.table(trim(dataset), file="/Program Files/R/R-3.3.3/1.txt", sep = "\t", row.names = FALSE) plot(dataset);
Regards,
Hi,
This works fine for smaller set of data, however when trying to export a bigger data set I'm getting the following error:
Any idea on how to work around this?
If you just need to export dataset to a file, you can try to use "Export Data" feature on Power BI Service: Export data from Power BI visualizations
Regards,
Hi,
@v-sihou-msft yes, but I would like to try exporting the data as automated as possible i.e. as little hands on as possbile. So idea was to schedule a report refresh doing this automated.
Are there any limitations exporting the data as you describe?
Best Regards
J
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
59 | |
51 |
User | Count |
---|---|
165 | |
83 | |
68 | |
68 | |
59 |