Skip navigation
All Places > ArcGIS Maps for Power BI > Blog > Author: SBall-esristaff

We've received a number of questions regarding how and when Power BI data is sent to Esri when Power BI users interact with the ArcGIS Maps for Power BI visual. I'd like to share these answers with the community so everyone is aware of when their data is - and isn't being sent to Esri for geoprocessing. 

 

Q: There are data going to and from the ArcGIS site.  I am assuming this is just address data for mapping purposes only. The question is what data is sent between Power BI and ArcGIS? And is this data being stored by ArcGIS?

A: Correct, only the data needed to geocode the address (ie, fields placed in the Location field well) are passed to Esri servers. These data are only used to generate the information used to place the locations on the map and they are not stored by Esri servers.

 

Q: Does ArcGIS offer a service where this data is not collected for internal use or shared with any partners?

A: As mentioned, we do not store this data. We also do not share it with partners. If data being passed to Esri is a concern, you can use the latitude and longitude field wells to map their point data instead of using the Location field well. When using the latitude and longitude field wells, no data is passed to Esri for mapping – but it does require you to have performed the geocoding process some other way.

 

Q: Does ArcGIS maps geo-coding have a limit on the number of waypoints that can be sent?  If so, what is the limit?  Is there a limit per day?

A: Limits to geocoding are on a per-map basis and can be found in our documentation here.

 

Q: Is it possible our address list or search history is never shared for marketing purposes to any partner of ArcGIS?

A: Address list and search history information from ArcGIS Maps for Power BI is never shared for any purpose to any partner of Esri.

Today we are excited to announce integration between ArcGIS Online and ArcGIS Maps for Power BI. This update is a part of the Microsoft Power BI Desktop May 2018 update and allows you to include feature layers and custom basemaps from your ArcGIS Online organization in your Power BI reports and dashboards. To date, only public feature layers and Esri default basemaps have been available to use in your ArcGIS Maps visuals in Power BI. Now, Level 1 or Level 2 named users in ArcGIS Online can sign into ArcGIS Maps for Power BI and start using secured content that is only available within their ArcGIS Online organization.

Maximize value by using ArcGIS and Power BI together

This is an exciting new capability for organizations that use both Microsoft Power BI and ArcGIS Online. Now it is as easy as adding your feature layers to a map visual on a shared Power BI report to distribute them throughout your organization, even to people who have no prior knowledge of GIS. (Keep in mind when sharing secured layers that report viewers will need to have the proper ArcGIS credentials to view secured content.)

 

Many organizations have standardized on Microsoft Power BI as their business intelligence tool-of-choice, and the ability to use authoritative location content from ArcGIS Online inside your business intelligence system will take your organization to the next level.

A new way to buy Plus subscriptions

We are also launching a new Plus subscription purchasing option with the May update. Plus subscriptions for ArcGIS Maps for Power BI are intended for Power BI users who need more capabilities than are included in the free map visual, but who don’t have or need to create private feature layers in ArcGIS Online. Since November, Plus subscriptions have been available for purchase individually, but this isn’t ideal when sharing reports with large numbers of people. With each person who views a report with Plus content needing their own Plus subscription, it can be unwieldy to have them all buying their own individual accounts.

 

Today we are launching the ability to purchase Plus subscriptions for your entire organization in one transaction. This will allow anyone in your organization that uses Power BI to view and share map visuals with Plus content.  To find out full details about what’s included with a Plus subscription, or to contact Esri about purchasing a Plus subscription for your organization – head on over to our product page.

 

For more details about ArcGIS Online integration or Plus subscriptions for your organization, take a look at the Microsoft blog we co-authored with Senior Program Manager Lukasz Pawlowski from Microsoft.

 

To review detailed system requirements and get our full documentation on the ArcGIS Maps for Power BI visual, head over to our help site.

 

Happy mapping!

Scott and the entire ArcGIS Maps for Power BI team

With the ArcGIS Maps for Power BI visual Esri has delivered great value into Microsoft Power BI. Starting today you can get even more content, capabilities, and value with a Plus subscription.

 

Images showing features of the Plus subscription

 

What's included?

When you become a Plus subscriber, you'll gain access to:

  • More basemaps (including satellite imagery, topographic, and more for a total of 12 basemaps you can use in the visual).
  • More geocoding. Plus subscribers can geocode 5,000 addresses per map (up from 1,500 for everyone else).
  • Esri's Living Atlas, a browse-able collection of global reference layers.
  • Thousands of global infographics showing demographics and spending patterns. 

 

What happens when I share a map with Plus features?

A Plus subscription is required to author and view maps with Plus content. If you share a map with Plus content with someone who is not a Plus subscriber, they will not be able to view the map until they also become a Plus subscriber. When authoring a map, keep an eye out for the Plus icon - it will help you know if you're adding content that can only be seen by other Plus subscribers.

 

 

How do you get it?

You'll notice a new icon in your map visual starting today. Click on the 'Sign up' button inside this new icon to go to the Esri site where you can enter your contact and credit card information. After successfully signing up for Plus you will get 60 days free. Your new Plus subscription will be $5/month after the free 60 day period. 

 

ArcGIS Maps for Power BI brings the best parts of the ArcGIS platform together into one awesome package. When pieces of ArcGIS get better, the ArcGIS Maps visual that utilize those pieces get better too! That's exactly what happened last night when the ArcGIS world geocoding service updated - you now have better location matching in Power BI.  

 

What exactly got better?

The update last night was to the world geocoding service, which is used to provide points when you use the Location field well. Geographic boundaries (like states, ZIP codes, and other areas) are provided by Esri geoenrichment services and were not affected by the update last night.

 

What changes will I notice?

  • You can now search for addresses in more countries than before. Previously the World Geocoding service boasted support for address-level geocoding in 109 countries. The list has expanded to an even more impressive 135 countries. We’ve also updated the reference data for most countries and added new authoritative address data sources for Australia (G-NAF) and Austria (BEV).
  • We’ve enhanced the behind-the-scenes matching logic for better handling of poorly-formed address searches. Geocoding in the USA consistently yields high match rates, but your address database may include questionable addresses with misspellings or extra information that can’t be geocoded, such as person names. The enhanced service is capable of handling this type of incorrect information. Below are a few examples of how these improvements can boost geocoding match rates even higher.

 

  • Our Defense and Intel users have always been able to easily search for MGRS (Military Grid Reference System) coordinates in ArcGIS Desktop. Unfortunately it wasn’t so simple to do the same in ArcGIS Maps for Power BI. For the first time, you will be able to search for MGRS coordinates – along with postal codes, addresses, populated places, and points of interest.  Additionally, you can now search for latitude/longitude coordinates in different formats, such as degrees-minutes-seconds (DMS), and can also find United State National Grid (USNG) coordinates (although we recommend you continue to use the Latitude and Longitude field wells when mapping coordinates).

  • Another useful feature in the updated service is the ability to locate Point of Interest (POI) names. You may have tables that include both addresses and place names, and in the past when you tried to batch geocode them there were no matches for the place names. There’s no longer such a disconnect which means you can batch geocode addresses, postal codes, and POIs, or any combination of these in the same field.

 

Keep an eye on the blogs here on the GeoNet site for the latest updates to ArcGIS and the ArcGIS Maps visual!

1. It’s now a core part of Microsoft Power BI!

As of today, the ArcGIS Maps visual graduated from Preview to general availability in Power BI desktop. That means it is available out of the box by default. No more File > Options > Options > Preview > Enable visual - just look for the Esri globe alongside your other Power BI visuals and start using it. The ArcGIS Maps visual will be available by default in Power BI service very soon as well.

 

 

2. It’s so easy to map your BI data

After adding the ArcGIS Map visual to your report, just drag a location field from your dataset into the Location field well and we’ll do the rest! The Location field well has smarts built in and it will try to figure out what you’re trying to map, whether it’s an address or standard geography, like Postal codes or country boundaries (and if it can’t figure out what you’re trying to add, you can always help it out).

 

3. You can make your maps uniquely yours

Sometimes ‘easy’ means ‘limited’, but that’s not the case with the ArcGIS Maps visual. Based on our years of cartographic experience we provide some smart defaults, but we also understand that you are going to want to tweak things from time to time. After mapping your data you can enter edit mode (use the … menu in the upper right corner) to customize your map to your hearts’ content. You can pick the basemap that makes your data look great, change your point or area styling to one of the Power BI default data colors (or any custom color of your choosing, such as your corporate color scheme), and adjust transparency, border thickness, symbol size and more to get your map just how you like it.

 

4. See new patterns in your data using heatmaps and clustering

If you have too many points on a map it can be hard to understand what you’re seeing. It’s times like these when heat maps and clustering can help make sense of your data. By aggregating points together using either of these map themes, you can clean up your map and help draw the readers’ eyes to the important places on your map.

 

 

5. Create drive-time areas to always know who (or what) is nearby

Drive time areas can be used to simply visualize the areas that are nearby your important locations. More powerfully, they can be used as a selection tool to filter and highlight other reports based on data points close to your important locations, allowing you to see unique spatial patterns in your data and answer questions like ‘what are the trends among my local customers compared to all customers?’

 

There are many other cool features in ArcGIS Maps for Power BI (such as demographic layers, ArcGIS reference layers, infographics, etc.) – so what are you waiting for? Fire up Power BI and see how ArcGIS Maps for Power BI can add a new dimension to your reports! Join the community and let us know your favorite things about the ArcGIS Maps visual (or ask questions to the product team, watch videos, or give us ideas about what you want to see in the product next!)

Welcome and thanks for joining ArcGIS Maps for Power BI on GeoNet! To get started we invite you to first review the group features on the overview page and familiarize yourself with the group info, admins and GeoNet 101 information in the left column.

 

As you explore the group, you’ll also find tools to connect and collaborate so we encourage you to use them to share files, create blogs, ask/answer questions and read the latest blogs posts and join discussions.

 

Next, we’d like to get to know you, so we invite you to post a comment below to say “hello" and introduce yourself. If you'd like to share a cool report you’ve made with the ArcGIS Maps visual, we love seeing what people are up to!  

 

We’re excited to connect and collaborate with you and we look forward to seeing your contributions.