Forum Discussion
ArcGIS Maps for Power BI (Preview) Discussion
Since we announced ArcGIS Maps for Power BI (Preview), we've been getting a lot of great questions and positive feedback.
Let's use this thread for a discussion of ArcGIS Maps for Power BI, including any issues you might encounter when using the feature.
You can now use the ArcGIS Maps for Power BI feature in the September release of Power BI Desktop. Remeber to enable it in the options menu.
You can find documentation here:
- Power BI documentation (How to enable, How to manage, etc.)
- Esri's ArcGIS Maps for Power BI documentation
- Esri's ArcGIS Maps for Power BI product page
Some have asked for features:
A) Sign in to ArcGIS Online; it's on the road map ... vote for this idea to keep updated
B) Shapefile support ... use the ShapeMap visual
Known Issues:
Starting Monday 2/14/2017 you may receive an error when opening Power BI desktop when you have enabled ArcGIS Maps for Power BI (preview). Please review this thread for further details. The workaround for this issue is documented here.
196 Replies
- quiphanNew Member
Hi all, would ArcGis be available on PowerBI Desktop and if so how to get it? thanks. Qui
- dcresp
Advocate IV
The ArcMaps Visual has a lot of potential but at the moment it is a little disapointing and still has a number of issues. Here are my major issue with it at this stage.
Not being able to add any Tooltips in limiting compared to using the standard maps.
The Tooltips that do come up do not extend past the Visual window as they do on standard maps. This means that a lot of my Tooltips can not be read by the user. This is a major negative for me.
When selecting colour and size map theme and adjusting the colour in the Symbol Styles the colours seem to get confused at times and there are a lot more colours coming up than there should be.
When using the Select Multiple Locations tool on the map my existing visuals show an error and state - Condn't load the data for this visual - We couldn't display the visual because a measure is used in cross highlighting. Please remove the measure or cross highlight.
I assume that this is somthing that I have done in correctly but not sure what. Any assistance with this would be apreciated.
Also it would be great if we could use maps that we have created in Arc as the reference layer maps.
I think this Visual has huge potential but it is not there yet and at this stage I am choosing to continue to use the existing mapping Visuals despite being excited when this was anounced.
Hopefully they will iron some of these issues out as the tool progresses through the preciew phase. Certainly lots of potential.
Regards
David
- djnww
Impactful Individual
I haven't tested it yet, but you highlighted somethign very important.
"Also it would be great if we could use maps that we have created in Arc as the reference layer maps"
I assumed it could do that. Let's hope that the Power BI team add that functionality while it is still in Preview.
I was hoping that other Shapefiles such as MapInfo would have been supported.
Cheers,
D
- AnonymousNot applicable
Thanks David (@dcresp) for the comments. As Art Haddad said, there's more to come. There are a bunch of things the team is working on and will address in subsequent builds of the visual. So check back frequently. For feature requests, please put them on https://ideas.powerbi.com.
That being said....
For the issue related to cross highlighting, could you start another thread, and include your Power BI Desktop file? We'd like to look into that.
For ArcGIS reference maps: today you can use public layers from ArcGIS Online or layers in Living Atlas. We plan to bring the ability to sign-in to an ArcGIS account, it's on the roadmap, but too early to talk timelines. Vote for this idea to be updated once this capability is available.
- scottball
Helper I
Hey David dcresp- Scott from the Esri team here. I echo the comments from Lukasz, and I want to reiterate that you CAN use layers that you've created in ArcGIS as the reference layer in your map. In order for them to show up in Power BI they need to be published as feature services and shared with everyone on ArcGIS Online.
Thanks for sharing your feedback, it definitely will be useful as we move forward with the development of this visual!
- chrisu
Responsive Resident
Suggestions for improvements:
- Retain zoom level when cross-filtering from another chart.
- Add tooltips.
- Allow customization of color schemes for dots.
- Free-draw/polygon select (in addition to box-select that is there now).
- Up the limit for displaying non-lat/long locations--1500 isn't near enough.
- scottball
Helper I
chrisu - thanks for the suggestions! Some of those are in the works, and we'll look into the others. Regarding #5 - the 1500 limit is only for locations that go to the Esri World Geocoding Service. You'll be able to tell these apart because they come back as points. Locations that come back as polygons (such as states, ZIP codes, countries, etc.) are processed through the Esri geoenrichment services and have a higher limit.
sjahta - this is a known issue that we are tracking. Should be fixed soon. Thanks for passing it along!
- acrobertsFrequent Visitor
Looks like exciting stuff! I'm not seeing ArcGIS in my Preview Features options - is this being rolled out to users in any particular order?
- Greg_Deckler
Community Champion
Just guessing that this will be in the September update to Desktop, which I imagine will be released today or in the next couple of days. If I have missed it, let me know!
- charmainer
Helper III
Hi,
Requsting your thoughts .. I have created a map in PowerBi Desktop. Published the same via the PowerBi service ...
I am part of Power Bi Pro trial user.
The map does not display. but it does display in Power Bi Desktop.
Just checking if u have had is issue and solved the same?
Cheers
Charmaine
- a_mixed_life
Resolver I
Pretty cool! Looking forward to this. Assuming this would be for the release on October?
- dcresp
Advocate IV
One other item that seems to be missing is that there does not seem to be any way to do a map legend. Am I missing somthing?
In terms of the shape map visual this is a very useful tool but the limiting factor is that there is not the option to be able to project this custom polygons over a map. Hopefully the Arc map visual will be able to address this.
- jcarville
Skilled Sharer
The ArcGIS Maps has me very excited for all the different ways that we can use it.
I can't wait to see this visual progress from preview into a full launch. To echo something that was said before me, I think a legend should be an option to be included on the visual.
- BI_MonkeyFrequent Visitor
scottball a couple of quick questions about what data goes where
1) Are the ESRI servers all in the US?
2) What gets sent from PBI to ESRI? Is it just the geocoding data or is there other data for the visual sent?
3) What gets send to PBI from ESRI? Is it just the map and geocoded location?
I have a very data sovereignty sensitive customer on my hands...
Cheers, James
- DuncanP
Advocate II
Hi
I've just got hold of a data set that includes plenty of UK postcode data, so I've broken it down into area, district and sector to start mapping it. So far it looks really impressive, except for a couple of weird anomolies.
One strange issue is when using currency data as the value in size or color on the map. You can see how the formatting is corrupted in some way. The measure is a fixed decimal formatted as currency (£ English) with comma separation and 2 decimal places.
I've also noticed that when using postcode areas, some are mapped in the wrong place. They are:
CF (Cardiff) - mapped as CB (Cambridge)
IM (Isle of Man) - mapped as CM (Chelmsford)
ST (Stoke on Trent) - mapped as AL (St Albans)
OL (Oldham) - also mapped as AL (St Albans)
WF (Wakefield) - mapped as WD (Watford)
Finally, it appears that incorrect postcode districts are sometimes mapped to real ones, which led to some considerable confusion on my part. So BR29 (which doesn't exist) was mapped over BS29, with the colour coming from the data corresponding to one district while the tooltip showed the data from the other. That led to me thinking that the colouring was messed up until I worked out what was going on! (Don't worry, I will fix my data ;))
Other than that though, this is pretty amazing from what I've seen so far - so thank you!
Cheers,
Duncan
- AnonymousNot applicable
Hey scottball, looks like there are a few mis-located points - could you look into these?
- gooranga1
Power Participant
hi DuncanP just browsing though this thread as I have just hit the misrepresented postal regions. Though I had hit the jackpot after giving up on trying to import shapefiles via the shapemap but the ST,CF,M,WF misplacement is the fly in the ointment.
I haevn't got to the end of the thread just wondered if you got a workaround for this?
Thanks
- Ian123Regular Visitor
I am also liking these new ArcGIS features.
Is it possible to specify locations using different coordinate systems than lat and long? Some of the data I am using for evaluation has poor quality address information but has an X,Y on offer to me.
- ChrisOnesBroken
Helper I
Ian123That's a really good question
"Is it possible to specify locations using different coordinate systems than lat and long? Some of the data I am using for evaluation has poor quality address information but has an X,Y on offer to me."
I'm in a similar situation. We have some legacy systems, and some external open data sources that have been created using eastings and northings, and we could really do with a range of options for various coordinate systems from disperate systems.