Forum Discussion
automatic export to excel
Does anyone know if there's a way to have data in Power BI Desktop exported out to an excel document automatically (without having to click on the ellipses and select Export Data) on a recurring basi...
I think you would be able to do this with a Trick using R. Add a new step in edit query with R language. In this step you receive the dataset use for e.g.
write.csv(dataset, file = "MyData.csv")
Then output the same dataset to continue the steps in edit query. With this, you may be able to generate automatically a .csv file on each update the gateway runs.
Regards,
P/D You must have R installed in order to make the operation.
But then how will my R script run if I finally publish my report?
Even if I use personal gateway this R script is for output data result in file so there is no source data connection in this case!