Forum Discussion
Scheduled refresh of SQL source but with R script transformstions
Hello. I am exploring using PBIRS as the server to host Power BI reports, which will extract/source data from a SQL Server Database, and which will subsequently use R scripts to transform the dat...
Using R for ETL seems like a bad idea - it's rather slow. You should be able to run R scripts from within Power Query (it is possible for the regular Power BI) or you could also consider running your R scripts directly on your SQL Server data source (assuming you use a new-ish version of SQL Server).