Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
09-26-2016 10:27 AM
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
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.
Thanks,
it's a great help for me to learn how to use R with Power BI.
Great work.
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.
Screen shots of my pages for:
2. Direct Comparisons
3. Distributions
4. Trends over time
Screen shots of my pages for:
5. Relationships
6. Percents
7. Special Cases