Layers lock without a match in join layer

[SJ-N1]

Hi, the company where i work is a merger of 2 largers companies, this means our GIS data is in 2 different layers.

I have joined both layers with my data using the "join layer" field which works fine, but i am experiencing problems with my layers locking.

It seems that if i use my slicers to filter the data, so that i only see assets that belong to layer A, then layer B will lock, and the other way around also. Is this just have the visual works? And i need to ask the GIS department to join the layers, or is there a known workaround?

Its version 2025.2.901, if thats important information 🙂

Regards
Sune

[KanikaKumar]

Hello,

It sounds like the visual is struggling to maintain active joins across two separate sources simultaneously. The best fix would be for the GIS department to 'Merge' these two layers into a single master Feature Class. This would give us one consistent Join Field.

A second option can be instead of joining them separately in the map visual,  try 'Appending' (Unioning) the data tables in the data prep layer (Power Query/SQL) first. > If we create one unified table that contains the IDs for both Layer A and Layer B, the visual will see it as one continuous dataset, which usually stops the 'locking' behavior when slicing.

Question: Do you have other BI visuals in addition to the ArcGIS for Power BI visual?

Thanks!