Using R packages in Power BI

0 votes
How can I use R packages in Power BI?
Feb 8, 2019 in Power BI by Upasana
• 8,620 points
1,100 views

2 answers to this question.

0 votes

You need to add the packages you want via the R Installation specified in the Power BI Options or you can add your R script in Power BI by clicking on the Get Data and then using the R script and pasting the code.

answered Feb 8, 2019 by Shubham
• 13,490 points
+1 vote

You can use the powerful R programming language to create visuals in the Power BI service. Many R packages are supported in the Power BI service (and more are being supported all the time), and some packages are not.

The following sections provide an alphabetical table of which R packages are supported in Power BI, and which are not. For more information about R in Power BI, see the R visuals article.

Request support for a new R package

Supported R packages for the Power BI service are found in the following section, titled Supported Packages. If you would like to request support of an R package not found in that list, you can send an email with your request to the R in Power BI Feedback Team.

Requirements and Limitations of R packages

There are a handful of requirements and limitations for R packages:

  • The Power BI service, for the most part, supports R packages with free and open-source software licenses such as GPL-2, GPL-3, MIT+, and so on.

  • The Power BI service supports packages published in CRAN. The service does not support private or custom R packages. Users are encouraged to make their private packages available on CRAN prior to requesting the package be available in the Power BI service.

  • The Power BI Desktop has two variations for R packages:

    • For R visuals, you can install any package, including custom R packages
    • For Custom R visuals, only public CRAN packages are supported for auto-installation of the packages
  • For security and privacy reasons, R packages that provide client-server queries over the World-Wide Web (such as RgoogleMaps) in the service, are not supported. Networking is blocked for such attempts. See the following section for a list of supported and unsupported R packages.

  • The approval process for including a new R package has a tree of dependencies; some dependencies required to be installed in the service cannot be supported.

R packages that are supported in Power BI

Package Version Link
abc 2.1 https://cran.r-project.org/web/packages/abc/index.html
abc.data 1 https://cran.r-project.org/web/packages/abc.data/index.html
abind 1.4-5 https://cran.r-project.org/web/packages/abind/index.html
abind tensor polyclip (>= 1.5-0)
acepack 1.4.1 https://cran.r-project.org/web/packages/acepack/index.html
actuar 2.1-1 https://cran.r-project.org/web/packages/actuar/index.html
ade4 1.7-6 https://cran.r-project.org/web/packages/ade4/index.html
AdMit 2.1.3 https://cran.r-project.org/web/packages/AdMit/index.html

answered Feb 8, 2019 by rajesh
• 1,270 points

Related Questions In Power BI

0 votes
1 answer

Are there any security considerations when using R or Python scripts in Power BI?

Using R or Python scripts on Power BI has certain security risks , ...READ MORE

answered Jan 23 in Power BI by anonymous
• 19,330 points
96 views
0 votes
1 answer

create interactive R plots in Power BI

 Right now Power BI only supports render ...READ MORE

answered Sep 20, 2018 in Power BI by Kalgi
• 52,350 points
1,393 views
0 votes
1 answer

list reports with calculated percentage in Power BI using dax

Create a Measure called Total Revenue: Total Revenue = SUMX( ...READ MORE

answered Oct 22, 2018 in Power BI by Hannah
• 18,520 points
1,723 views
0 votes
1 answer

Embedding a dashboard using Java in Power BI

Make sure to use the correct embedURL, ...READ MORE

answered Nov 30, 2018 in Power BI by Shubham
• 13,490 points
5,216 views
0 votes
1 answer

How do you embed dashboard using JavaScript in Power BI?

Make sure the use the correct embedURL ...READ MORE

answered Oct 10, 2023 in Power BI by Monika kale

edited Mar 5 2,156 views
0 votes
1 answer

How do you use R visuals in Power BI Desktop?

Hi, In order to use R Visuals you ...READ MORE

answered Apr 10, 2019 in Power BI by Avantika
• 1,520 points
869 views
0 votes
1 answer

Using R packages in Power BI

When you're trying to use R on ...READ MORE

answered Dec 17, 2018 in Power BI by Shubham
• 13,490 points
852 views
0 votes
0 answers

Create a sample report in power BI using R script

how to create a sample chart using ...READ MORE

Jun 20, 2019 in Power BI by Anitha
723 views
0 votes
1 answer

How to verify that R and R studio are installed on your system?

To verify that R and R studio ...READ MORE

answered Nov 11, 2020 in Power BI by Gitika
• 65,770 points
590 views
0 votes
1 answer

Big Data transformations with R

Dear Koushik, Hope you are doing great. You can ...READ MORE

answered Dec 18, 2017 in Data Analytics by Sudhir
• 1,570 points
1,172 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP