Joins using text fields are broken

[JCable]

We have discovered that a side effect of yesterday's 2024.2.550 update has resulted in text-based joins to no longer work. Files that had existing text-joins (setup using the previous version) are now broken and new joins fail to find any matches during validation. This is a major bug that has needs to be fixed immediately!

[JCable]

@AlagiriVenkatachal Thanks so much for the quick turnaround!

[LydiaStekkinger]

Thank you! We now have a temporary workaround through ArcGIS Online. But quick fix is appreciated.

[NaZhang_Esri]

Hi @JCable,

Thanks for letting us know! The text based join works fine on my side. Much appreciated if you could provide the detailed steps for us to reproduce like @AlagiriVenkatachal  mentioned. 

[NaZhang_Esri · Accepted solution]

Hi @JCable and @LydiaStekkinger ,

Thank you for bringing this to our attention. We are pleased to inform you that the bug you reported has been resolved in the latest update of ArcGIS for Power BI (version 2024.2.560). To access the fix, please restart Power BI.

Should you encounter any further issues or have additional questions, please don't hesitate to reach out. We're here to help!

cc: @AlagiriVenkatachal 

[TravisLoseke1]

We are not able to get the joins to work with ArcGIS Enterprise.   We are consistently getting an error when trying to select on the map after the join is made.

[GIS-celVlaams-Brabant]

Hi @NaZhang_Esri 

We are also running into issues with the join layer. I’m currently on version 2024.2.500.0 and I can't seem to upgrade to a more recent version (not by installing the latest Power BI version manually from Microsoft.com or by downloading it through the Microsoft Store).

I have setup a join-layer and a filter to zoom in on different custom polygons. The issues I have are as follows:

• The join layer does work for a bit.. but stops working once I try to use the select tool.
• The select tool does not work at all.
• When join layer is "working", the map sometimes does not react to a filter and the filter needs to be clicked once more to have an effect.
• When going from one filter to another, often there is smooth transition, but other times it just jumps.

We are just starting to explore the option of working with Power BI (and the ArcGIS integration). However, the initial impression left us sligthly dissapointed. Fingers crossed this can be resolved.

Best regards,
Wouter

[LydiaStekkinger]

Thank you for solving this!