Use R language to modify query in Power BI
This tutorial describes how t use R to modify queries in Power BI. Click here to see how to use R for visuals or here to see how to use R for data source definition.
To make the following approach available, R has to be installed.
So how to use R directly in query?
First, we need some query. When ready, we can create a step (probably something that can be done easier in R then in Power BI environment.
As Power BI suggest, the table created from previous query steps can be found in "dataset" data.frame.
new_dataset = dataset[,-5]
This command simply removes the fifth column. Yes, this is too simple and you don´t need R to make this step, since columns can be normally deleted in query.
With this command new step (or two steps, actually...) are added. And any normal query step can follow.