How “ArcGIS Maps for Power BI” Will Transform My Work with Power BI

With the September release of Microsoft Power BI Desktop, the recently announced ArcGIS Maps for Power BI are available in preview. After having an opportunity to use the Esri ArcGIS map for the first time in PBI Desktop, it is an impressive step up from what Power BI had before.

How impressive? Here’s how maps changed overnight in Power BI:

pbinativetoarcgis

 

  1. You can now make beautiful and functional maps in Power BI. It is on par with standard fare from other BI tools like Tableau as well as a lot of basic customized maps you could make with open source tools.
  2. Alternative base layers are available. The default is now light gray. Someday I might clamor for alternative basemaps from Esri, but for now, dark and light options are a large step up for data visualization in Power BI. I can see my data without the Bing/HERE streets and colors getting in the way.
  3. Reference layers that depict demographics or other spatial attributes are available. If the defaults are not enough, you can search ArcGIS for more. I found that there are thousands of options that ArcGIS Online users have made publicly available.
  4. I could probably add a dozen items to this list — just try the maps yourself and use the existing Map or Filled Map alongside the new ArcGIS Maps.

 

Here’s a personal story showcasing how the new maps will transform how I use Power BI.

Earlier this year, I was asked to prepare a demo showcasing a sample “outage” map in Microsoft Power BI. If you have ever had a power outage, you may have checked your electrical utility’s website to see the extent of outages in your area and view their expected restoration times. For a standard example, here is my local energy company’s outage map. There was also a particular requirement to have outages cluster together as you zoomed out on the map. Armed with an idea, I built a quick sample dataset and went to work.

Could the standard Power BI map get me there? Somewhat, but not really. I could plot points. Clustering was not possible. This is what the customers for the potential client would see when they checked for outages:

utilitysample-powerbioriginal

The other map options for Power BI such as the Filled Map, Synoptic Panel and even the R visual (due to it being a static image) also could not satisfy all of the demo requirements.

As a result, I built a prototype using Leaflet and Leaflet’s marker cluster plugin. I found a GeoJSON file for a US city’s neighborhoods for added perspective and plotted my sample data. You can view the interactive map here or see a screenshot below.

utilitysample-leaflet

 

I then started building a Power BI custom visual based on that Leaflet prototype, but…

utilitysample-pbicustomvisual

 

Custom visuals are a lot of work… Too much work for a non-billable demo (and way too much work to get them to a state where they can be deployed in a production environment). I probably spent about an hour on the Leaflet prototype and two or three hours on adapting it as a demo-ready Power BI custom visual (clustering never worked by the way).

Fast forward to today, and the screenshot below shows the same data using ArcGIS Maps in Power BI. This took five minutes. That includes the time it took to find the Washington DC neighborhood outline reference layer from ArcGIS Online, build the custom DAX tooltip, and change the default colors and other formatting. This map also satisfies the original requirements with the ability to cluster points as you zoom out. With the light gray background, it also looks great and allows you to immediately focus on the data.

utilitysample-powerbi

 

The main takeaway from this story for me is that I no longer need to waste time or tell someone “it’s not possible” to make functional and attractive maps in Power BI.

I’ll continue to use Leaflet and Mapbox for fun outside of Power BI. They have some great plugins that Power BI still cannot beat, but building custom maps is not my job — working with the Microsoft data platform is.

Between the Shape Map that was released earlier this summer and the new ArcGIS Maps for Power BI, I think Power BI has less need for time-consuming mapping workarounds. It took patience to get to this point, but Power BI’s mapping capabilities certainly took a step up.

Advertisements

2 thoughts on “How “ArcGIS Maps for Power BI” Will Transform My Work with Power BI

  1. This always seemed like a powerful combination. I was worried that Esri was not going to do this when they introduced their own BI app, “Insights” (http://www.esri.com/products/arcgis-capabilities/insights) earlier in the year. I guess they saw the light of the ever growing user-base that Power BI is developing.

    There’s still a lot that’s missing from my perspective and I trust will be integrated with final. For instance, being able to search on one’s own organizational ArcGIS Online (or Portal) account. (FYI, this is an Idea you can vote on, search on “Connect to ArcGIS Online through ArcGIS Maps for Power BI”.)

    Searching on everything that has ever been published as public is a unfortunate start. I highly recommend reviewing the Search documentation (https://doc.arcgis.com/en/arcgis-online/reference/search.htm) for tips on how to refine a search for better results. For instance if just type “Counties” into the search box I get a whole lot of..well, let’s just say a lot. If I use the owner field in the search term I can ensure that I get only layers curated by someone I know as an authoritative source. By adding “owner:esri”, now I am only seeing counties that have been curated by Esri. On a related note, the federal government seems to curate under the group, “Federal_User_Community”. For the moment, if someone wants to leverage their own spatial data they would have to be willing to share it publicly and then could filter for it using the owner field.

    All in all, an encouraging start and hopefully Esri can get on the Power BI development cycle with monthly updates.

    Liked by 1 person

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s