idea Join layer on Power BI applicable when menu not open. in ArcGIS for Power BI Ideas

Join layer on Power BI applicable when menu not open.

FMGLGIS — Thu, 16 Jun 2022 07:20:16 GMT

Please enable the join layer functionality even when the widget's settings pane is not open. It currently only operates as expected when the join layer is open, which requires dashboard users to go through 4-5 menus to get to this option. This is not reasonable to expect a dashboard viewer/non gis user to do.

I would like the users to use filters on the rest of the dashboards page and have the map filter to the joined features, without having to set it up each time.

Details: https://community.esri.com/t5/arcgis-for-power-bi-questions/arcgis-maps-for-power-bi-join-feature-not-working/m-p/1121128#M945

Re: Join layer on Power BI applicable when menu not open.

DarylV — Thu, 16 Jun 2022 20:10:51 GMT

Completely agree. Most (or all?) visuals in powerbi behave with 'filter-on-click' functionality for joined data. Please can this visual be able to filter on join layer in the same way. Having to open the join menu is not intuitive. If not the default functionality, at least could this style of interaction be enabled in the settings via toggle?

Also, once the filtering is selected, can a 'auto zoom to selected' function automatically be called. Or, again, can this option be available via a toggle?

Re: Join layer on Power BI applicable when menu not open.

RodPBI — Fri, 01 Jul 2022 21:07:32 GMT

I think the functionality that Esri is bringing to the visual is awesome, and it gets better with every release. However, this Idea has to be high on the list. The ability to join is soooo cool, but rendered useless for our target user because of this issue. Heck, an interim solution that allows direct interaction with no extra steps using just a feature layer from AGOL or Portal would be great (if such a solution helps the effort).

Re: Join layer on Power BI applicable when menu not open.

Anonymous User — Wed, 06 Jul 2022 20:58:19 GMT

Fully agree; our use case is discussed in the mentioned thread ArcGIS Maps for Power Bi join feature not work... - Esri Community . Requiring users to open the join widget to have the join functionality and filters work isn't useable.

Re: Join layer on Power BI applicable when menu not open.

RemoteMC — Wed, 13 Jul 2022 08:48:59 GMT

Fully agree, this should be a priority.This should be the default functionality for user experience and usability. Moreover, it blocks quite some extent of the maps' information.

Re: Join layer on Power BI applicable when menu not open.

StevenBowden — Wed, 21 Sep 2022 02:37:02 GMT

Completely agree that this should be fixed ASAP. This can't be rolled out organisational wide or used in an Enterprise situation as it currently stands.

Re: Join layer on Power BI applicable when menu not open.

MorganPenk — Fri, 01 Sep 2023 20:16:39 GMT

I just want to comment in hopes that this issue becomes addressed!! This is the one of the most important features of Power BI ArcGIS map and it unusable in its current state. It has been over two years since I have seen comments mentioning this and no updates as of yet.

Re: Join layer on Power BI applicable when menu not open.

JoeBryant1 — Tue, 31 Oct 2023 20:52:24 GMT

Another upvote to fix this issue ASAP! It looks very bad when you are developing dashboards for a large organization that has invested heavily in ESRI software to have to use a third party solution outside of ArcGIS to achieve simple join filtering for Power BI. Lots of promise, but currently un-usable.

Re: Join layer on Power BI applicable when menu not open.

Sam_Keast — Mon, 11 Dec 2023 03:04:39 GMT

How has this not been implemented yet? We've got users jumping over to MapBox to run simple joins to tables, despite investing in ESRI tech overall as an organization.

I'm not sure what use case exists for a "join feature" that only works when the user has navigated into a menu system and left the join window open?

This functionality is sorely needed to make ArcGIS Maps for PowerBI even worth considering as an option

Re: Join layer on Power BI applicable when menu not open.

BenClark — Mon, 08 Jan 2024 21:24:36 GMT

I was taken aback when I learned today that the join settings don't persist once the window is closed. Please, please fix this ASAP, ESRI. The join function is practically useless in its current state.

Re: Join layer on Power BI applicable when menu not open.

InsaH — Tue, 16 Jan 2024 09:35:02 GMT

Fully agree, this should be a priority, please!

Re: Join layer on Power BI applicable when menu not open.

AnneTetley — Tue, 23 Jan 2024 15:43:56 GMT

Fully agree too, this is preventing us from fully recommending the ESRI plug in as the corporate solution for mapping in Power BI. End users of published dashboards aren't going to manage to find the Join layer tool and it obscures most of the map unless you make the map much bigger than you'd generally want if its embedded with other data and items in the dashboard..

Re: Join layer on Power BI applicable when menu not open.

MarkHodgson — Thu, 25 Apr 2024 10:41:11 GMT

Jumping on the bandwagon here, though a little late to the party. Having the same experience and issues and while I want to fly the flag for ArcGIS, with this current limitation my company will invest in other solutions. Anyone at esri able to provide an update?

Re: Join layer on Power BI applicable when menu not open.

AndrewJca — Wed, 19 Jun 2024 14:53:13 GMT

Full agreement with everyone here, it's this missing functionality that's holding us back from implementing solutions with ArcGIS and PowerBI. Sorting this out ASAP should be top on the list for developers.

Re: Join layer on Power BI applicable when menu not open.

Luisalf — Thu, 20 Jun 2024 10:14:02 GMT

Same problem here!

It is a shame that an error of this nature deprives you of the use of one of the most attractive features of the tool.

Regards!

Re: Join layer on Power BI applicable when menu not open.

AnthonyLatini — Wed, 26 Jun 2024 16:12:26 GMT

Good morning all!

Thank you for your patience on this issue. As mentioned in previous posts, this was something that the team had been working on and we know had been a massive pain point for everyone (us included).

I am happy to announce that the latest version of ArcGIS for Power BI has started its deployment process and should be rolled out to all regions over the next few weeks.

One of the biggest changes outside of UI/UX enhancements, is the ability to use the Join Layer widget without having the window open. Take a look at the animation below. I can now make selections and filter the layer and Power BI data without the need to have the window open.

We will be making additional enhancements to the Join Layer widget, but we thought this was a great start!

Please let me know if you have any questions.

Re: Join layer on Power BI applicable when menu not open. - Status changed to: Closed

NaZhang_Esri — Fri, 17 Oct 2025 19:02:00 GMT

This idea has been implemented.