cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Exporting data using R

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:

 

Capture.JPG

 


 
The steps that I’ve used:
1. Create new report (page1)
2. Choosing two columns (BLNumber, ChrgWeight) from table (PS_total)
 test.png
3. Applying R script visual

test2.png
 
4. Getting the R script editor

test3.png
 
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

4 REPLIES 4
Highlighted
Microsoft
Microsoft

@J_4923

 

As I tested, you need to grant the permisson for "ALL APPLICATION PACKAGES" and "ALL RESTRICTED APPLICATION PACKAGES" on that text file security.

 

89.PNG

 

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);

 

 

 

78.PNG

 

88.PNG

 

Regards,

Highlighted

Hi,

@v-sihou-msft

This works fine for smaller set of data, however when trying to export a bigger data set I'm getting the following error:

 

Capture.JPG

 

Any idea on how to work around this?

Highlighted

@J_4923

 

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,

Highlighted

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors