<p><div><div><div><div data-width="100" data-show-faces="false" data-send="true" data-layout="button_count" data-height="21" data-href="https://www.r-bloggers.com/r-with-power-bi-import-transform-visualize-and-share/"></div></div><div><a data-url="https://www.r-bloggers.com/r-with-power-bi-import-transform-visualize-and-share/" data-counturl="https://www.r-bloggers.com/r-with-power-bi-import-transform-visualize-and-share/" data-count="horizontal" data-text="R with Power BI: Import, Transform, Visualize and Share" class="twitter-share-button" data-via="rbloggers" href="https://twitter.com/share"></a></div><div></div></div><div></div></div>
<div>
(This article was first published on <strong><a href="http://blog.revolutionanalytics.com/2016/08/powerbi-and-r.html"> Revolutions</a></strong>, and kindly contributed to <a rel="nofollow" href="https://www.r-bloggers.com/">R-bloggers)</a> </div>
<div>
<p><a target="_blank" href="https://powerbi.microsoft.com/en-us/">Power BI</a>, Microsoft's data visualization and reporting platform, has made great strides in the past year integrating the <a target="_blank" href="https://mran.microsoft.com/documents/what-is-r/">R language</a>. This Computerworld article describes the <a target="_blank" href="http://www.computerworld.com/article/3109533/business-intelligence/microsoft-ratchets-up-its-r-enthusiasm.html">recent advances with Power BI and R</a>. In short, you can:</p>
<ul>
<li><a target="_blank" href="http://blog.revolutionanalytics.com/2015/11/powerbi-adds-support-for-r.html">import data into Power BI</a> by using an R script</li>
<li><a target="_blank" href="https://powerbi.microsoft.com/en-us/blog/data-cleansing-with-r-in-power-bi/">cleanse and transform other data sources coming into Power BI</a> using R functions</li>
<li>create <a target="_blank" href="https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-r-visuals/">custom charts in a Power BI dashboard using the R language</a>, like <a target="_blank" href="http://blog.revolutionanalytics.com/2016/02/r-maps-in-powerbi.html">these maps</a></li>
<li>share R scripts with others for use with Power BI in the <a target="_blank" href="http://community.powerbi.com/t5/R-Script-Showcase/bd-p/RVisuals">R Scripts Showcase</a></li>
<li>create dashboards with Power BI desktop and R on your local machine, and <a target="_blank" href="https://powerbi.microsoft.com/en-us/blog/r-visuals-in-powerbi-service/">share them with others using Power BI Online</a></li>
</ul>
<p><a target="_blank" href="http://revolution-computing.typepad.com/.a/6a010534b1db25970b01b7c88b8f82970b-pi"><img title="Power BI capabilities" alt="Power BI capabilities" src="http://revolution-computing.typepad.com/.a/6a010534b1db25970b01b7c88b8f82970b-800wi" border="0"></a></p>
<p>Power BI desktop is <a target="_blank" href="https://powerbi.microsoft.com/en-us/get-started/">completely free to download and use</a>, and includes all the features you need to create visualizations, reports and dashboards. (Publishing to Power BI online requires a subscription, though.) Power BI desktop and R are both included in the <a target="_blank" href="https://azure.microsoft.com/en-us/marketplace/partners/microsoft-ads/standard-data-science-vm/">Data Science Virtual Machine</a>, so that's another easy way to get started.</p>
<p>Sharon Laivand from the Power BI engineering team recently gave a <a target="_blank" href="http://event.on24.com/eventRegistration/console/EventConsoleApollo.jsp?&eventid=1232451&sessionid=1&username=&partnerref=&format=fhaudio&mobile=false&flashsupportedmobiledevice=false&helpcenter=false&key=5B402039FD97C1AC0955BDAE63F6BBBC&text_language_id=en&playerwidth=1000&playerheight=650&overwritelobby=y&eventuserid=148478377&contenttype=A&mediametricsessionid=118013146&mediametricid=1790292&usercd=148478377&mode=launch#">webinar showcasing the capabilities of Power BI and R</a>. Fast-forward to the 29-minute mark to see how to create a report incorporating R-based calculations and graphics, and then share it with others (even people who don't have R installed!) using Power BI online. </p>
<p>For more information about Power BI, visit <a target="_blank" href="https://powerbi.microsoft.com/">powerbi.microsoft.com</a>.</p>
</div>
<p><div><div><div><div data-width="55" data-show-faces="false" data-send="true" data-layout="box_count" data-height="62" data-href="https://www.r-bloggers.com/r-with-power-bi-import-transform-visualize-and-share/"></div></div><div><a data-url="https://www.r-bloggers.com/r-with-power-bi-import-transform-visualize-and-share/" data-counturl="https://www.r-bloggers.com/r-with-power-bi-import-transform-visualize-and-share/" data-count="vertical" data-text="R with Power BI: Import, Transform, Visualize and Share" class="twitter-share-button" data-via="rbloggers" href="https://twitter.com/share"></a></div><div></div></div><div></div></div>
<div>
<div>To <strong>leave a comment</strong> for the author, please follow the link and comment on their blog: <strong><a href="http://blog.revolutionanalytics.com/2016/08/powerbi-and-r.html"> Revolutions</a></strong>.</div>
<hr>
<a rel="nofollow" href="https://www.r-bloggers.com/">R-bloggers.com</a> offers <strong><a rel="nofollow" href="https://feedburner.google.com/fb/a/mailverify?uri=RBloggers">daily e-mail updates</a></strong> about <a title="The R Project for Statistical Computing" rel="nofollow" href="https://www.r-project.org/">R</a> news and <a title="R tutorials" rel="nofollow" href="https://www.r-bloggers.com/?s=tutorial">tutorials</a> on topics such as: <a title="Data science" rel="nofollow" href="https://www.r-bloggers.com/?s=data%20science">Data science</a>, <a title="Big Data" rel="nofollow" href="https://www.r-bloggers.com/?s=Big%20Data">Big Data, <a title="R jobs" rel="nofollow" href="https://www.r-users.com/">R jobs</a>, visualization (<a title="ggplot and ggplot2 tutorials" rel="nofollow" href="https://www.r-bloggers.com/?s=ggplot2">ggplot2</a>, <a title="Boxplots using lattice and ggplot2 tutorials" rel="nofollow" href="https://www.r-bloggers.com/?s=boxplot">Boxplots</a>, <a title="Maps and gis" rel="nofollow" href="https://www.r-bloggers.com/?s=map">maps</a>, <a title="Animation in R" rel="nofollow" href="https://www.r-bloggers.com/?s=animation">animation</a>), programming (<a title="RStudio IDE for R" rel="nofollow" href="https://www.r-bloggers.com/?s=RStudio">RStudio</a>, <a title="Sweave and literate programming" rel="nofollow" href="https://www.r-bloggers.com/?s=sweave">Sweave</a>, <a title="LaTeX in R" rel="nofollow" href="https://www.r-bloggers.com/?s=LaTeX">LaTeX</a>, <a title="SQL and databases" rel="nofollow" href="https://www.r-bloggers.com/?s=SQL">SQL</a>, <a title="Eclipse IDE for R" rel="nofollow" href="https://www.r-bloggers.com/?s=eclipse">Eclipse</a>, <a title="git and github, Version Control System" rel="nofollow" href="https://www.r-bloggers.com/?s=git">git</a>, <a title="Large data in R using Hadoop" rel="nofollow" href="https://www.r-bloggers.com/?s=hadoop">hadoop</a>, <a title="Web Scraping of google, facebook, yahoo, twitter and more using R" rel="nofollow" href="https://www.r-bloggers.com/?s=Web+Scraping">Web Scraping</a>) statistics (<a title="Regressions and ANOVA analysis tutorials" rel="nofollow" href="https://www.r-bloggers.com/?s=regression">regression</a>, <a title="principal component analysis tutorial" rel="nofollow" href="https://www.r-bloggers.com/?s=PCA">PCA</a>, <a title="Time series" rel="nofollow" href="https://www.r-bloggers.com/?s=time+series">time series</a>, <a title="finance trading" rel="nofollow" href="https://www.r-bloggers.com/?s=trading">trading</a>) and more...
<img height="1" alt="" width="1" src="http://feeds.feedburner.com/~r/RBloggers/~4/JfMTRheRBmA"></a></div>