Community
Select to view content in your preferred language

ArcGIS Onine Data Doesn't Load When Searching PowerBI Analysis Window for Join

166
5
4 weeks ago
GBacon
by
Frequent Contributor
4 weeks ago

I was following along with this blog article and noticed I could not add ArcGIS Online data to select a field for a join (see steps 5 and 6 in the first section of the article). This happens with some feature layers but not others. I didn't have any problems loading the data shown in the attached when I searched using the layer stack. Has anyone else encountered this? @NaZhang_Esri 

Tags (1)
Preview file
198 KB
Preview file
68 KB
0 Kudos
5 Replies
NaZhang_Esri
by Esri Contributor
Esri Contributor
4 weeks ago

Hi @GBacon ,

Thanks very much for your question! Nice try on the join layer! I hope the blog is helpful and the tool is more useful. 

 

From the screenshot, could you please make sure they are the same layers for better comparison? It seemed like the layer from Add layer tool is a single layer but the layer on the Join layer tool is a group layer. 

If you want to join the group layer, have you tried to click on the chevron to expand the layer? Once you expand the layer, you should be able to join the feature layer within the group layer.

NaZhang_Esri_0-1750885773475.png

NaZhang_Esri_1-1750885781017.png

 

Please let me know if you have more questions. Thank you!

0 Kudos
GBacon
by
Frequent Contributor
4 weeks ago

My arrow in the LayerStack graphic was pointing to the wrong layer so I fixed it. Sorry about that. I can confirm it is the same publicly shared layer as the one in the analysis join window.  Here is the Supervisor Districts item: https://fairfaxcountygis.maps.arcgis.com/home/item.html?id=1e026c9a9605454ab6b1515e6896216a

There is only one layer in this item and it can be found with key words Fairfax County Supervisor Districts if you can give it a try.

0 Kudos
NaZhang_Esri
by Esri Contributor
Esri Contributor
4 weeks ago

Hi @GBacon -

 

I see what you are asking now. Thanks for providing the layer detail. This is very helpful! We will look into it. If you want to join this layer, I would suggest adding the layer from ArcGIS and create a join for the layer. See my screenshots below.

NaZhang_Esri_2-1750954240894.png

 

NaZhang_Esri_0-1750954124010.png

NaZhang_Esri_1-1750954129224.png

 

 

GBacon
by
Frequent Contributor
4 weeks ago

Thanks again. That is the order I was accustomed to for a join and I was curious when I saw the *excellent* blog article show another way. 

NaZhang_Esri
by Esri Contributor
Esri Contributor
4 weeks ago

@GBacon - That's awesome! Good catch on this issue. I have logged it. 

0 Kudos