cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
The_Birdman
New Member

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

1 REPLY 1
lbendlin
Super User
Super User

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

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.