Scheduled refresh of SQL source but with R script transformstions

Question

Hello.&nbsp;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 data in various ways.&nbsp;Per the link below, as far as I understand R scripts themselves are not a source which can have PBIRS scheduled refreshes applied to them. &nbsp;As such, I'm wondering the following:&nbsp;1.) Is there a way to work around this so that I can in fact schedule refreshes of a single R script which will hold the code for the entire ETL,&nbsp;2.) If SQL Server Database is the source and transformations are applied using R scripts, does scheduled refresh work in this scenario?&nbsp;https://docs.microsoft.com/en-us/power-bi/report-server/data-sources#list-of-supported-authentication-methods-for-model-refresh

lbendlin · Answer

Using R for ETL seems like a bad idea - it's rather slow.&nbsp; 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).

Forum Discussion

Related content

Schedule refresh

Schedule refresh

Scheduled Refresh Failure

Power BI - Schedule refresh

Scheduled Refresh