Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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).
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
6 | |
4 | |
3 | |
3 |
User | Count |
---|---|
15 | |
9 | |
6 | |
3 | |
3 |