Forum Discussion

J_4923's avatar
J_4923
Frequent Visitor
9 years ago

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 mes...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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.

 

 

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,

  • J_4923's avatar
    J_4923
    Frequent Visitor
    9 years ago

    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:

     

     

    Any idea on how to work around this?

      • J_4923's avatar
        J_4923
        Frequent Visitor
        9 years ago

        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