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 statistics.
Run Power BI and connect to your Dynamics NAV database. Select the CRONUS International Ltd_$Detailed Vendor Ledg_ Entry table for the data source and edit the query.
In the query editor, click Choose Columns and select three columns for...