From the course: Machine Learning with Data Reduction in Excel, R, and Power BI
Join today to access over 24,800 courses taught by industry experts.
Setting up R in Power Query Editor
From the course: Machine Learning with Data Reduction in Excel, R, and Power BI
Setting up R in Power Query Editor
- [Instructor] Within Power BI, we can set up R scripts in two places. We can set them up in the Power Query Editor when we connect to the data source and transform the data in the ETL framework before loading it into power BI. We can also run R scripts to create custom visuals within a standard power BI R visual. In this video, we're going to focus on running R scripts within Power Query. If you haven't already downloaded R to your computer and set it up in Power BI desktop, please visit the video in the introductory chapter where I rock through how to do this. In R, I've referenced the K means algorithm, where we use the averages data frame to create three clusters on our data set. We're going to input this into Power BI desktop. In Power BI desktop let's select Get data, we'll then look for R script and connect to it. We want the output of our R script to be a tabular data frame like the R data frame structure.…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.