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
968 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

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,295 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,624 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,014 views
0 votes
1 answer

How do you embed dashboard using JavaScript in Power BI?

Dashboards in Power BI can be embedded ...READ MORE

answered Mar 5, 2019 in Power BI by Phalguni
• 1,020 points
2,052 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
703 views
0 votes
1 answer

How To use R Integration in Power BI?

Hi,  There are a lot of packages available ...READ MORE

answered May 3, 2019 in Power BI by Avantika
• 1,520 points
2,624 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
768 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
663 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
518 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,036 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