Does R script write.table work in PBI Service?

[Whiskeybar]

Hello!

I have an R-script running in Power Query in PBI desktop which transforms my input data and saves output data as csv in a certain directory (thanks, @curbal!) 

Here is the script:

require(gdata)
write.table(dataset, file="xxx, sep = ";", row.names = FALSE, na = "", quote = FALSE);

I am now trying to make it work in Power Bi Service  - with scheduled refresh - hoping that the Service will save the csv the same way my Desktop did, but it does not work 😞 

Has anyone managed to find a workaround to automate data exporting from PBI Service?

Thank you very much!

[v-shex-msft · Accepted solution]

HI @Whiskeybar ,

I don't think it is possible to run these script code on power bi service. They will been blocked due to security and permission reasons.

Regards,

Xiaoxin Sheng

[Whiskeybar]

Thank you for reply! I will be looking for another workaround , then...