The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Description
Prerequisites (The sample .pbix files will not work without these prerequites completed)
1. Install R Engine
Power BI Desktop does not include, deploy or install the R engine. To run R scripts in Power BI Desktop, you must separately installR on your local computer. You can download and install R for free from many locations, including the Revolution Open download page, and the CRAN Repository.
2. Install the required R packages.
Download the R script attached to this message and run it to install all required packages on your local machine.
Required R packages:
dplyr, ggplot2, ggthemes, zoo
Tested on:
CRAN 3.3.1, MRO 3.3.0, powerbi.com
@Anonymous Looks nice and thanks for adding the R installation script!
@vrocca Thanks! In R studio I usually use the install.packages('packagename') to add a new package. And above your script or markdown document library('packagename')
Hi @fathomson,
I'm new to R and just installed Microsoft R Open onto my laptop. I have also downloaded the rscript. However, when I click on Packages->Install Packages....this appears ( see attached).
I think I'm perhaps doing it wrong. Ultimately, I need the 2 dimension heat map to be on powerbi so that I can use it on my data. I'm a bit confused as to how to go about this so would be great if you could list down a step by step guide to this.
Thanks,
Lina
Hi @fathomson,
I'm new to R and just installed Microsoft R Open onto my laptop. I have also downloaded the rscript. However, when I click on Packages->Install Packages....this appears ( see attached).
I think I'm perhaps doing it wrong. Ultimately, I need the 2 dimension heat map to be on powerbi so that I can use it on my data. I'm a bit confused as to how to go about this so would be great if you could list down a step by step guide to this.
Thanks,
Lina
Is there any way we could change this from a count per hour / day. To an average count per hour / day?
I wish I'd seen this posting before I started my example...
My version uses the same ggplot and geom_tile functions as @fathomson but, rather than use R to massage the data with dplyr etc., it links directly to fields dragged from PBI - a typical Date dimension column and uses a calculated Time Bucket column as the other dimension against which to map the Call Count measure. I DO use the 'complete' function from the 'tidyr' package to fill in missing values and avoid holes in the heatmap.
I also played with presenting the value of the measure on the tile and some other formatting options. I tried to use the viridis palette package, but it's not supported on PBI Service yet.
Required R packages: ggplot2, ggthemes, tidyr. (see attached R script)
Matrix Heatmap
Here are the links to download the packages referenced:
dplyr: https://cran.r-project.org/src/contrib/dplyr_0.5.0.tar.gz
ggplot2: https://cran.r-project.org/src/contrib/ggplot2_2.1.0.tar.gz
ggthemes: https://cran.fhcrc.org/src/contrib/ggthemes_3.2.0.tar.gz
zoo: https://cran.r-project.org/src/contrib/zoo_1.7-13.tar.gz
Alternatively, you can install these throug R Studio by clicking on Packages > Install and entering the name of the package.
Hope that helps.
There doesnt appear to be any R script attached to this topic?