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

By David Smith

(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…

Source:: R News

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.