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