Forum Discussion

oslosa's avatar
oslosa
Helper I
6 years ago

Refresh not running R script

Hi, I have data that is updated every day, but I want to store historical values so that they are not overwritten. The way I am trying to do this is to export my dataset and append it to a csv file, ...
Need Help
jonsey1995's avatar
jonsey1995
Frequent Visitor
3 years ago

Also having this issue, has a solution been found?

 

R query i'm using 

install.packages("openxlsx")
library("openxlsx")
write.xlsx(dataset, "removed this but is a valid directory", asTable = TRUE, overwrite = TRUE)

 

When i refresh preview in power query, file is created/ overwritten correctly.

 

However when refreshing using powerBI Desktop the file is not created/overwritten