Tips and tricks on using R to query data in Power BI

August 25, 2017

(This article was first published on Revolutions, and kindly contributed to R-bloggers)

In Power BI, the dashboarding and reporting tool, you can use R to filter, transform, or restructure data via the Query Editor. For example, you could use the mice package to impute missing values, or use the tidytext package to assign sentiment scores to text inputs. As Imke Feldmann explains, there are lots of useful tricks you can accomplish using R in the query editor, including:

  • Passing multiple Power BI tables into the R script
  • Parameterizing R scripts
  • Modifying file names and output data types for use in Power BI
  • Generating multiple table outputs from an R script

For the details on these tips, follow the link below. You can also find tips on using R in the Query Editor here.

The Biccountant: Tips and Tricks for R scripts in the query editor in Power BI

To leave a comment for the author, please follow the link and comment on their blog: Revolutions. offers daily e-mail updates about R news and tutorials on topics such as: Data science, Big Data, R jobs, visualization (ggplot2, Boxplots, maps, animation), programming (RStudio, Sweave, LaTeX, SQL, Eclipse, git, hadoop, Web Scraping) statistics (regression, PCA, time series, trading) and more...

If you got this far, why not subscribe for updates from the site? Choose your flavor: e-mail, twitter, RSS, or facebook...

Comments are closed.

Search R-bloggers


Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)