From the course: Power BI Weekly

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Running R script on existing query

Running R script on existing query - Power BI Tutorial

From the course: Power BI Weekly

Start my 1-month free trial Buy for my team

Running R script on existing query

“

- [Narrator] R is a popular statistical programming language we can leverage for data science models like clustering or regression. We can use R in Power BI to run scripts in Power Query or to create visuals once we load the data. In order to run our scripts anywhere in Power BI, we need to properly configure it both on our computer and also within Power BI desktop itself. Within Power Query, we can use R scripts to pull data originally from the data source when we set up the initial data connection, we can also use it on top of an existing query that we already set up to another connection type within the Power Query editor. For example, we might want to connect to a Power BI data flow and transform this connection. Then run a model on top of these existing steps using an R script, we can think of these R scripts running on top of existing connections within Power Query, a bit like sandwiches because we can continue to form…

Contents