R is a software environment for data mining, statistical analysis, and data presentation. It is widely used in statistical applications for sophisticated modeling and data mining solutions. R scripts can be executed in Power BI with the NAV database as the data source for computations.
The R environment must be installed for this demo. Download and install R from https://cran.r-project.org.
For a detailed description of how to connect to the Dynamics NAV database with Power Query, remove the columns from the dataset and change the column data type, refer to the recipe Retrieving data from NAV with Power Query.
In this recipe, we will use R to build a box plot based on expenses ...