R Pivot Table custom visual for Power BI - DataVeld

New R Packages Available in Power BI Service

Microsoft recently updated the R version for Power BI Service and installed numerous additional R packages. For comparison, I posted the then-current list of packages back in July 2017. If you use R in Power BI Service, definitely see what’s available in the screenshots at the end of this post. Hopefully the Power BI documentation…

What *Undocumented* R Packages Exist in Power BI Service?

In my last post, I examined the list of R packages supported in Power BI Service. After some additional research, it turns out that I should have titled it “documented” instead of “supported”. Why is that? In addition to the 361 documented packages, there are over 200 undocumented R packages currently available to users in Power…

What R Packages Are Supported in Power BI Service?

Microsoft maintains an official list of supported R packages available for use in the Power BI Service. There are currently 361 documented packages. While you are not as limited in your package selection when using Power BI Desktop, you have to be more careful if you are working with R in the online Service. If you use…

R Tools for Visual Studio

The BlueGranite blog recently featured a post I wrote about R Tools for Visual Studio. It’s not meant to be an in-depth exploration into RTVS. Rather, at a high level, it takes a very basic look at some reasons why a developer may choose to use RTVS either in conjunction with or in lieu of R…

Microsoft R: A Revolution in Advanced Analytics

One of the benefits of working on a team at BlueGranite is the collective expertise that I can tap into when needed. Whether it’s a skill that I am learning or a problem that I am stumped on, one or more of my colleagues typically has the ability to point me in the right direction. To…

R Visuals or Custom Visuals in Microsoft Power BI?

Over the past few years, there has been a movement in R to create packages that bind to JavaScript libraries to make R more interactive. Notably, htmlwidgets and rCharts are two examples that come to mind. In an IDE like R Studio or a framework such as Shiny, the enhanced visualization appears and functions like it would if…

R Maps in Microsoft Power BI: Small Multiples

After an initial introduction to R maps in Power BI, let’s explore another topic: small multiples. This technique is used to make comparisons by showing variations of the same map plotted together in a grid. It is not limited to maps though. Nearly every type of plot could work well when viewed as a small multiple.   Small multiples…

R Maps in Microsoft Power BI: Getting Started

Are you using maps in Power BI but desire more control over the final visual? The following tutorial introduces the potential for using R to move beyond the default maps in Power BI. Starting with basics, we will step through a series of simple maps that plot airfield locations in the Great Lakes region of the United States. Although there are many mapping…