cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Sowmiya Helper III
Helper III

Export Data Using R from Power BI Service

Hi Community,

I have created table using R Script in Power Bi Desktop and I have added script to export data from R Scripted Table. It works fine and data exported to the path as I mentioned in the Script in Power BI Desktop. When I publish same report to Power Bi Service, Script Ran successfully without any error. I could not find the path where the exported data located in Power BI Service. Please do needful as earlier.

Following is my script I have used
----------------------------------------------------------------------------------------
dataset <- data.frame(ref, ref1, ref2, ref3,ref4)
dataset <- unique(dataset)
library(gridExtra)
a<-data.frame(dataset$ref,dataset$ref1,dataset$ref2,dataset$ref3)
colnames(a) <- c("Ref", "Risk Value","Title","Desc")

file<-dataset$ref4[1]
file1<-paste("~/",paste(file,".csv",sep=''),sep='')             # "~/"  it refers to default working directory (path) of R
if(dataset$Output.2[1] == "Export")
{
zz <- file(description=file1, "w")
write.csv(a, zz)
close(zz)
}
grid.table("Exported")
----------------------------------------------------------------------------------------
Thanks in Advance,
Sowmiya

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: Export Data Using R from Power BI Service

Hi @Sowmiya ,

 

I am afraid that Power BI servce doesn't support it currently.

You could refer to this resolved case:

https://community.powerbi.com/t5/Service/Error-while-exporting-data-in-csv-file-using-R-script-in-po...

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

1 REPLY 1
Community Support
Community Support

Re: Export Data Using R from Power BI Service

Hi @Sowmiya ,

 

I am afraid that Power BI servce doesn't support it currently.

You could refer to this resolved case:

https://community.powerbi.com/t5/Service/Error-while-exporting-data-in-csv-file-using-R-script-in-po...

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.