Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

ArcGIS is not showing join layer in reference layer options

Submitted by Anonymous on ‎01-11-2023 03:25 AM

I am trying to add layer join param in Arc GIS map viusal in power bi but it doesn't appear in layer options. Please, If you have any idea how to fix it ? I am suggesting that It is related to the new updates. 

Status: Investigating
See more ideas labeled with:
6 Comments (6 New)
Comments
Anonymous
Not applicable
‎01-11-2023 10:13 PM

Hi @Anonymous ,

 

To use the layer join feature, ensure that the ArcGIS reference layer contains attributes that match those in the Power BI dataset. The name of the attribute does not have to be identical, but the data type must be the same; you join numbers to numbers, strings to strings, and so on.

Join layers—ArcGIS for Power BI | Documentation

 

The Power BI ArcGIS-plugin has been upgraded with multi layer feature

Work with layers—ArcGIS for Power BI | Documentation

 

You may also check if it helps

No Location? No Problem! Join Layers in ArcGIS for Power BI - ArcGIS Blog (esri.com)

 

Best regards.
Community Support Team_ Caitlyn

 

pmor
Regular Visitor
‎01-18-2024 08:55 PM

We cannot see the 'Layer Join' option either only 'Zoom to Layer' and 'Remove'

The reference layer contains a join attribute which is the same data type as the data layer. But I tried strings or numbers just in case.

As far as I can tell we have the latest ArcGIS for PBI 2023.2.187

pmor_0-1705636670957.png

 

Was there a solution or something which is not being done correctly?

eseiling
New Member
‎02-06-2024 10:52 AM

I'm also having this issue- Join Layer is not an option in the dropdown - only "zoom to layer" and "remove"

mathmis
Regular Visitor
‎03-20-2024 02:50 AM

I have the same issue. I tried connected to an OLAP cube and also a Excel file.

Someone know how to fix it ?

 

hgaignard
New Member
‎05-31-2024 03:27 AM

Hi,

 

To show Join Layer option in the reference layer’s context menu, you need drag the join field (e.g NAME) from your Power BI dataset into the Power BI Join Layer field :

 

join-layer-field.png

 

Refer to this article : https://www.esri.com/arcgis-blog/products/power-bi/data-management/no-location-no-problem-join-layer...

chrisread79
Regular Visitor
‎06-12-2024 08:24 AM

I am experiencing this issue. I've added the correct data type field to the Join Layer box, but still no Join menu item appears. Did anyone resolve this? Is it still under investigation?

 

Arcgis for PBI join.PNG

Idea Statuses