nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

ArcGIS Maps for Power Bi join feature not working

estud1os_113

Hi,

I am trying to use the join feature available in the ArcGIS Maps for Power Bi visual to connect data in my Power Bi report to data uploaded to our ArcGIS Online server. When I try doing the join it seems to work but once I try filtering the visual using a slicer the map doesn't respond it just keeps loading endlessly.

This video demonstrates what we would like to accomplish using the join feature: Join Your Data to ArcGIS Layers - YouTube

However, this is a video I recorded showing what happens when I try doing the join myself: https://vimeo.com/644026377/041bd3b6ac

Have others experienced issues with this feature?

Thanks in advance!

Find more posts tagged with

Accepted answers

ismaeloltra

I have the same problem, if you leave the JOIN layer pop up open, as per my screenshot, it will allow you to use the filter.

join_layer_workaround.png

All comments

ismaeloltra

I have the same problem, if you leave the JOIN layer pop up open, as per my screenshot, it will allow you to use the filter.

join_layer_workaround.png

estud1os_113

Wow! Thank you so much! Not ideal but it works! Hopefully this bug will be corrected soon.

Anonymous User

@Anonymous User I'm experiencing the same issue. Filters only work if the Join layer window is open. This is with version 2021.2.95.

QuintsShark

Hi All, please excuse me if this is covered elsewhere, but is this a known issue and a fix will be forthcoming?

The workaround is great, but it's not a solution that is acceptable for a published report. Our users will not understand the steps necessary, or more importantly, want to apply all of the steps to be able to filter.

Any help would be greatful received.

Many thanks

estud1os_113

Hi, unfortunately we also decided that this workaround was not acceptable and moved on from ArcGIS. We are now using Mapbox which also has limitations, but the join feature from published layers in their server works fairly well in Power Bi.

I haven't tried using the ArcGIS visual recently so I am unable to tell you if this issue has been fixed or not.

Anonymous User

I can confirm with version 2022.2.105 of the map this bug is still there. Without the join layer widget open it doesn't filter the joined data.The workaround isn't acceptable for end users and currently ArcGIS Maps for Power BI has a number of issues. It took me ages to get around the login issue that keeps occuring and despite clearing cache folders, restart etc. the login window would flash up over the map and then disappear.
@AnthonyLatini

AnthonyLatini

Good afternoon all!

I was looking over a few of these comments related to the Join layer feature. Currently, to use this feature, the Join layer widget must remain open while making selections. The reason for this is because of some unique infrastructure/environment variables that are currently preventing us from accessing and selecting these items directly. For example, if you have a Power BI Data layer on the map (e.g., addresses), the selection tools will only interact with the Power BI Data layer when selecting them.

We are currently enhancing this feature and working on some BUGs that were reported, however, there is always room for improvement in general.

I would encourage to post in our Ideas page to enhance this feature. I have also added a reference page for the Join Layer documentation.

Ideas: ArcGIS for Power BI Ideas - Esri Community

Reference: Join layers—ArcGIS for Power BI | Documentation

Anonymous User

Thanks for your response, it's much appreciated. Good to get clarification on how this should work. However, if you take the perspective of a general user, they don't want to know how to open the join layer widget just so that their filter is applied correctly to the map. I get where you're coming from if you're a spatial user and are using it map centrically. But from a non spatial user's perspective it just doesn't work e.g. the image in my post above where the user wants to select the areas that apply, to filter the rest of the data on the page, and have the same filtering apply to the map.

RodPBI

Comforting to know that I'm not the only one that's suffering from multiple issues that, when combined, make the visual un-usable (in terms of expectations) beyond maybe a demo or a simple solution. I find I often start with the ArcGIS visual (because my users want it), but when it comes to crunch time and production needs, I end up using MS Bing maps or (occasionally) Mapbox... The thing is, once these issues get ironed out, ArcGIS has all the potential to be the go to visual for Power BI mapping needs.

RemoteMC

Good to know more people are having this issue. This is marked as "solved" but it is merely a work around that is not user friendly and/or intuitive. Please give this high priority for the next release.

AnneTetley

Hi Anthony,

Do you know if there have been any further developments on this? Is the requirement to leave the Join layer dialogue open for the interactivity to work any nearer to being resolved or is it with us for the foreseeable future?

Many thanks

Anne

ScottLarkin

Hi ESRI,

Also wanting to know if this bug (feature) has got any traction to being resolved?

You cannot expect the general user to know this step to interact/slice there data using a reference layer.

Regards

Scott

AnthonyLatini

Hi @ScottLarkin and @AnneTetley - My apologies for not seeing this. Sometimes the posts in here get lost!

I know this feature is quite troublesome. As mentioned in a previous post, the infrastructure in which we built this feature was incredibly restricting. However, we have this on our project board to resolve this year (post 2024 Esri User Conference).

I do apologize as I know this has been a pain point for a long time. And I agree, having the window open is not ideal. However, it was (at the time) the only way to make Power BI know that data was on the map.

Please bear with us as we now have a path forward to make this a better experience for everyone. Thank you for your patience on this issue!

ScottLarkin

Hi @AnthonyLatini,

Thanks for getting back to me so quickly, I understand the hurdles that need to be jumped (and sometimes compromised) for a product to be delivered.

I look forward to the fix/resolution post the User Conference, fingers crossed.

Regards

Scott

TheSecondDude

I am also looking forward to this fix 🙂

MarkHodgson

Feeling optimistic about this fix later this year, thanks for the update @AnthonyLatini

odubois_spw

Hello @AnthonyLatini ,

Do you have any update on this topic? I really need too this feature update.

Regards,

Olivier

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.