Configuring the Power BI service to work with R
As you learned in the The R engines used by Power BI section of this chapter, the Power BI service uses different R engines depending on whether the scripts are used in R visuals or in Power Query for data transformation. In the first case, the engine is pre-installed on the cloud; in the second case, you need to install the on-premises data gateway in personal mode on any machine of your choice in order to make the Power BI service communicate with the R engine you installed on that machine.
Installing the on-premises data gateway in personal mode
We have emphasized the fact that you will need to install the data gateway in personal mode for an important reason: R scripts are not supported for the on-premises data gateway in Enterprise mode.
In your case, you will install the data gateway on the same laptop on which you have installed the R engines and Power BI Desktop. The steps to do this are as follows:
- Make sure...
