skip to main content
Power BI
    • What is Power BI
    • Why Power BI
    • Customer stories
    • Data visuals
    • Security
    • Power BI Desktop
    • Power BI Pro
    • Power BI Premium
    • Power BI Mobile
    • Power BI Embedded
    • Power BI Report Server
  • Pricing
    • Azure + Power BI
    • Office 365 + Power BI
      • Energy
      • Healthcare
      • Manufacturing
      • Media
      • Retail
    • For analysts
    • For IT
      • Overview
      • Embedded analytics
      • Power BI visuals
      • Automation
      • Documentation
      • Community
    • Overview
    • Find consulting services
    • Partner showcase
    • Find a partner
    • Become a partner
    • Instructor-led training
    • Getting started
      • Overview
      • Online workshops
      • Self-guided learning
      • Webinars
      • Documentation
      • Roadmap
      • Overview
      • Issues
      • Give feedback
    • Blog
    • Business intelligence topics
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • Events
    • User groups
    • Community blog
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Galleries
    • Community Connections & How-To Videos
    • COVID-19 Data Stories Gallery
    • Themes Gallery
    • Data Stories Gallery
    • R Script Showcase
    • Webinars and Video Gallery
    • Quick Measures Gallery
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Microsoft Power BI Community
    • Galleries
    • R Script Showcase
    • Re: Power BI demo - Creating Effective Graphs with...

    Re: Power BI demo - Creating Effective Graphs with Microsoft R Open

    02-12-2017 13:17 PM

    is_ibrahim
    New Member
    33635 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    mike_honey
    mike_honey Memorable Member
    Memorable Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    Power BI demo - Creating Effective Graphs with Microsoft R Open

    ‎09-26-2016 10:08 AM
    This demo is a companion to the excellent white paper and sample project: Creating Effective Graphs with Microsoft R Open, by by Naomi B. Robbins and Joyce Robbins:
     
    https://github.com/nbrgraphs/mro 
     
    In this demo file I have implemented the R scripts and Graphs shown in that white paper using Power BI, to showcase it's R Integration features. The pages in this report correspond to the Chapters in the white paper.
     
    Where text/CSV files were used in the white paper, I have replaced the R code to load them with data from a Power BI Query. This gives an opportunity to demonstrate Power BI's interactive filtering, where Slicers or other visuals can be selected to filter and dynamically generate R graphs.
     
    In my opinion Power BI represents a great platform to host R graphs/visualizations, and mash up R data integration scripts with Power BI data integration.
     
    The example below shows 4 R graphs all controlled by a single Power BI slicer, with no extra code required:
     

    EffectiveGraphsMRO doc sample Power BI.png

    Preview file
    158 KB
    ScriptInstallPackagesForCreatingEffectiveGraphs.R
    Power BI demo - Creating Effective Graphs with Microsoft R Open.pbix
    Labels:
    • Labels:
    • General R Visualizations
    Message 1 of 7
    35,765 Views
    13
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    is_ibrahim
    is_ibrahim
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎02-12-2017 01:17 PM

    Hi Mike,

     

    I've a question that is more related to Integration Architecture between PowerBI and HDInsight. Let's assume that my data is stored in Azure Storage Account or Data Lake STorage, and I have also HDInsight cluster running Microsoft R Server. In PowerBI, I need the R visual script to work on a massive amount of data stored in Data Lake Storage and run using Microsoft R Server, then it returns a relatively managebale dataset to be visualised. 

     

    Is this architecture attainable?

     

    Thanks.

    Is

    Message 7 of 7
    33,635 Views
    0
    Reply
    boefraty
    Microsoft boefraty
    Microsoft
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎11-22-2016 04:25 AM

    This is an amazing work.  If you consider to convert some of your R-visuals to R-powered-custom visuals, out team will be happy to assist you.  Almost all of these visuals are great candidates for the PBI Gallery ! I tested the support for R-packages in service, all of the  packages beside "micromapST" are already supported.

     

    The visibility of R-powered custom visuals in gallery is greater and it is not limited for R-users. 

    Message 6 of 7
    34,434 Views
    0
    Reply
    kavasimihaly
    kavasimihaly
    Frequent Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎11-02-2016 03:04 PM

    Thanks,

    it's a great help for me to learn how to use R with Power BI.

     

    Great work.

    Message 5 of 7
    34,765 Views
    1
    Reply
    mike_honey
    mike_honey Memorable Member
    Memorable Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎09-26-2016 10:27 AM

    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:

    stats, lattice, MASS, ggplot2, tidyr, HH, dplyr, micromapST


    Tested on:

    CRAN 3.3.1, MRO 3.3.1, Power BI Desktop 2.38 (August 2016)

     

    Legal Disclaimers:

    Terms of Service and Third Party Programs.

     

    Message 2 of 7
    35,754 Views
    2
    Reply
    mike_honey
    mike_honey Memorable Member
    Memorable Member
    In response to mike_honey
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎09-30-2016 02:37 PM

    Screen shots of my pages for:

     

    2. Direct Comparisons

     

    EffectiveGraphsMRO doc sample Power BI - Section 2 Direct Comparisons.png

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    3. Distributions

     

    EffectiveGraphsMRO doc sample Power BI - Section 3 Distributions.png

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    4. Trends over time

     

    EffectiveGraphsMRO doc sample Power BI - Section 4 Trends over time.png

    Message 3 of 7
    35,510 Views
    0
    Reply
    mike_honey
    mike_honey Memorable Member
    Memorable Member
    In response to mike_honey
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎09-30-2016 03:04 PM

    Screen shots of my pages for:

     

     

    5. Relationships

     

    EffectiveGraphsMRO doc sample Power BI - Section 5 Relationships (cont).png

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    EffectiveGraphsMRO doc sample Power BI - Section 5 Relationships.png

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    6. Percents

     

    EffectiveGraphsMRO doc sample Power BI - Section 6 Percents (cont).png

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    EffectiveGraphsMRO doc sample Power BI - Section 6 Percents.png

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    7. Special Cases

     

    EffectiveGraphsMRO doc sample Power BI - Section 7 Special Cases.png

    Message 4 of 7
    35,507 Views
    2
    Reply

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Automate
    • Power Virtual Agents

    • Sign in
    • Sign up

    Browse

    • Solutions
    • Partners
    • Consulting Services

    Downloads

    • Power BI Desktop
    • Power BI Mobile
    • Power BI Report Server
    • See all downloads

    Learn

    • Guided learning
    • Documentation
    • Support
    • Community
    • Give feedback
    • Webinars
    • Developers
    • Blog
    • Newsletter

    © 2022 Microsoft

    Follow Power BI

    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks