Scheduled refresh of SQL source but with R script transformstions

Anonymous — Fri, 06 Aug 2021 09:54:42 GMT

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 data in various ways.

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. As such, I'm wondering the following:

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,

2.) If SQL Server Database is the source and transformations are applied using R scripts, does scheduled refresh work in this scenario?

https://docs.microsoft.com/en-us/power-bi/report-server/data-sources#list-of-supported-authentication-methods-for-model-refresh

Re: Scheduled refresh of SQL source but with R script transformstions

lbendlin — Fri, 06 Aug 2021 21:54:29 GMT

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).

topic Re: Scheduled refresh of SQL source but with R script transformstions in Report Server

Scheduled refresh of SQL source but with R script transformstions

Re: Scheduled refresh of SQL source but with R script transformstions