Našimi kurzy prošlo více než 10 000+ účastníků
2 392 ověřených referencí účastníků našich kurzů. Přesvědčte se sami
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.
2 392 ověřených referencí účastníků našich kurzů. Přesvědčte se sami
Pište kdykoliv. Odpovíme do 24h
© exceltown.com / 2006 - 2023 Vyrobilo studio bARTvisions s.r.o.