Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
shantanugupta
Frequent Visitor

Is it necessary to install R and R studio to view graphs in Power BI

Is it necessary to install R and R studio to view graphs in Power BI? One of the colleagues, whom I am sharing my Power BI report doesnot have R installed in that PC. It throws this error. 

 

shantanugupta_0-1627213839807.png

Is there any way we can see the R graphs in Power BI without installing R programming into the system. Or is it necessary to install R language into the system to view the all the graphs generated from R in Power BI?

 

Here is the code:

# The following code to create a dataframe and remove duplicated rows is always executed and acts as a preamble for your script:

# dataset <- data.frame(PrimResult, DupResult, Element)
# dataset <- unique(dataset)

# Paste or type your script code here:
if (!require("tidyverse"))
install.packages("tidyverse", repos = "https://cran.r-project.org/")
if (!require("ggplot2"))
install.packages("ggplot2", repos = "https://cran.r-project.org/")
library(ggplot2)
library(tidyverse)

#dataset[is.na(dataset)] = 0
#qqplot(my_data$PrimResult.Theoretical., my_data$DupResult.Practical.,
# )

## - QQplots in GGPlot2
dataset %>%
ggplot(aes(
theoretical = PrimResult,
sample = log(DupResult)
)) +
stat_qq() +
stat_qq_line() +
labs(title = "QQplots", caption = "X-axis logged") +
ylab("Theoretical") +
xlab("Calculated")
1 REPLY 1
MattAllington
Community Champion
Community Champion

 If you want R to work in Power BI desktop, you have to install it separately. https://exceleratorbi.com.au/extending-power-bi-r-visuals/

if you publish the report to powerbi.com, it will work without installing R in the desktop (mostly)



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.