From the course: Machine Learning with Logistic Regression in Excel, R, and Power BI

Configuring R in Power BI

From the course: Machine Learning with Logistic Regression in Excel, R, and Power BI

Start my 1-month free trial Buy for my team

Configuring R in Power BI

“

- In this course, we're going to leverage Power BI to explore how to make logistic regression models more scalable and accessible. Power BI is a Microsoft business intelligence tool enabling a data driven culture across an organization. I personally think defining it as a communication tool, gets us thinking about how to maximize its impact across the end users. You can learn more about Power BI on Microsoft's homepage you see on the screen. Power BI Pro and also Premium are subscription services that enable us to share analysis with end users, as well as schedule automatic dataset refreshing. Power BI Desktop is a free version you can download to your own computer to develop and design data models and interactive visualizations. For this course we're using Power BI Pro account, to share work and refresh our data. You'll need an email address specific to your organization to sign up for any of these service accounts. But your organization may have passed to take care of this for you. On the Power BI webpage you see on the screen, you can see the available service accounts by scrolling down. We can see these options include Power BI Pro, Power BI Premium and Power BI Mobile. In this course we're mostly going to leverage Power BI Pro as well as, use Power BI Desktop to develop our models. If you don't already have Power BI Desktop installed on your computer, the link to download the most recent version is quite easy to find, on the Power BI section of the Microsoft website. Check the limitations of your computer to determine what version you should download, but it's a pretty straightforward process otherwise. You simply click on the link to download Power BI Desktop which is Try Power BI for free, and your computer will automatically start the download process. To use R directly in Power BI Desktop, you'll first need to install the version of R that works with the Power BI cloud accounts. You'll also need to install any libraries or packages necessary to run the model in R. In the video for installing R, in this chapter, you can see how to install the, the version of R we're using and also the libraries. Lastly, you'll need to enable R scripts directly in Power BI Desktop. Once you upload your Power BI Desktop file, denoted with the PBIX extension, the R scripts will run from the Power BI cloud account instead of your own computer. Once you've downloaded R in Power BI Desktop, you can enable scripts for R by going to the options menu in the file section and selecting options and settings, we'll then select options. We'll then select the R scripting option on the left side of the screen. We can choose the R directory that we downloaded the version, we want to use to our computer. You can set up a new R home directory by selecting browse and choosing the folder and file paths for your own R directory. Once you've selected this option, you want to confirm it, by selecting okay at the bottom of the screen. Once you select this option, you'll close out of Power BI Desktop completely and reopen it to enable R scripts to run within the application.

Contents