ArcGIS for Power BI - v2024.1

4009
12
06-30-2024 12:01 AM
AnthonyLatini
Esri Contributor
14 12 4,009

ArcGIS for Power BI is updated regularly to provide new features, improved speed and usability, and bug fixes. The 2024.1 (June/July 2024) update is a quality release. Performance improvements, UI/UX overhauls, bug fixes, design polishes, and quality of life updates have been made for the following features. 

Please make sure to update to the latest version of Power BI Desktop or refresh Power BI Online before upgrading.

As always, please let us know of any improvements or issues you want to chat about!

This version has started deploying in many regions. It may take up to three weeks to be deployed in all Power BI environments.

----

Reflection over the last year

It has been quite some time since our last major release of ArcGIS for Power BI. Over the last year or so, we have been working hard to upgrade multiple areas of the component including bug fixes, user experience, performance, and many others.

Now that we have fully migrated to a unified experience across the ArcGIS for Microsoft 365 components, we can provide regular updates in ArcGIS for Power BI. Getting to this point was a monumental task for the team and we hope that our work shines through.

As a note, there are some new workflows and experiences that you will encounter. As with any major upgrade, our goal was to make sure that no previous work was lost as much as we could. When upgrading software, it can be tough to retain older components or workflows as technology advances at an exponential rate.

That said, our work can only go so far. It’s you, the thousands of folks who use this daily, that make this work possible. Your ideas, bug reports, and feedback help us make the best possible software.

This is a huge milestone for the team, and we hope you enjoy what we have done and all the future work that is coming!

---

UI/UX Overhaul

Across all the ArcGIS for Microsoft 365 components, our team has given each component a new, streamlined user interface and experience. The new interface makes use of Microsoft's Fluent 2 design library and places common widgets in the same location across all the components.

We wanted this experience to be familiar whether you are working in ArcGIS for Power BI or in ArcGIS for Excel. You’ll see that menus can be resized, minimized, or removed completely. We’ve kept the teal theme to match the rest of the components in Power BI as well. Have a look and let us know what you think!

AnthonyLatini_1-1719729704022.png

 

Power BI Tooltips

Over the course of this component’s life, it has been our goal to work as close to Power BI ecosystem as possible. A major pain-point in the ArcGIS for Power BI component has been the way we handle tooltips and pop-ups for the Power BI data layer. In this release, we have migrated to using Power BI’s tooltip framework. This also means that you can make use of report tooltips in ArcGIS for Power BI now.

Keep in mind that there are differences between the versions of tooltips, however, the secondary goal of this change was to make sure that the map was no longer obscured. Further, tooltip annoyances such as windows popping up randomly or not over the correct feature have been addressed. This might change some of the workflows and the way your reports have been previously, but this was a necessary change to keep up with Power BI’s ecosystem and the usability of our component.

AnthonyLatini_2-1719729704032.png

 

Feature Information

Now that we have moved to using Power BI’s native tooltip system, we needed to move the pop-ups from ArcGIS reference layers to a better location so that they wouldn’t obscure the map. For this, we’ve created a new Feature Information pane to display pop-ups from your ArcGIS layers. It can be toggled on or off from the Format pane.

To learn more about the Feature Information pane and Tooltips, check out this fantastic article written by Na Zhang. 

Using Tooltip and ArcGIS technology to deep dive information in Power BI (esri.com)

AnthonyLatini_5-1719730812327.png

 

Join Layer

The idea behind the Join Layer widget is to help you bring your spatial data from an ArcGIS layer and join it together with non-spatial data that lives inside your Power BI dataset. In this release, we have fixed a major pain-point when using the widget: the window must remain open when a join has been created.

In this release, you can now perform actions with the window open, minimized, or closed completely. Give it a try and let us know what you think. We are going to be enhancing the Join Layer widget even further later this year.

Take a look at the animation below. I am using a reference layer from ArcGIS and I am controlling the other visualizations on the report page. This is a joined layer and no longer requires the widget pane to be open. 

JoinLayerUpdate.gif

 

Legend Support

We have added the ability to use a Legend in all the ArcGIS for Microsoft 365 components. You can add one or many layers to it, rename the legend, resize it, and even minimize it. We figured that this was a good starting point for the components as we have never had a true legend added to the map. We will be making enhancements to this widget in future releases this year and next.

AnthonyLatini_6-1719730889866.png

 

Bug fixes and polishes

Now at this point, I would usually list out all of the bugs, UI/UX polishes, and quality of life updates made to the component. I can safely say that there are far too many to list in this release. As mentioned in many other posts on these forums, the goal of these fixes and UI/UX polishes is to make it easier to navigate and create meaningful maps for your report.

Now that we have a unified experience across all ArcGIS for Microsoft 365 components, we would love to hear your feedback, whether it be an idea or if something is broken. Having open communication about the visual and how we can improve will keep us moving forward and paving the way for GIS in the Microsoft 365 ecosystem.

 

12 Comments
BrettMartin1
Occasional Contributor

Since the update users can no longer turn layers on and off in the layer list. Whatever is configured to be on at the time the report is published is the only layers available in the map. There is not a layer list in the map, only a legend. Why was this changed? 

 

The fix: the update blew up all ArcGIS for PowerBI visualizations. That had to be rebuilt and all reports republished. We then noticed the move away from pop ups in reference layers to "Feature Information". The update in general is a good one, but I hope future updates do not cause this much disruption in production applications. 

hgaignard
Esri Contributor

Hi @AnthonyLatini,

Unable to connect to ArcGIS for Power BI since update (2024.1.400) :

  • Error message for ArcGIS Online : Cannot read properties of undefined (reading 'error')

hgaignard_0-1720623187129.png

  • ArcGIS Enterprise URL not recognized : The ArcGIS Online (or ArcGIS Enterprise) URL specified is invalid.

hgaignard_1-1720623200763.png

 

BrettMartin1
Occasional Contributor

@hgaignard I saw this with an older version of desktop app after update with Enterprise only. Worked fine in the newest version. 

Roland_at_Planet
Emerging Contributor

This update broke the ability to use a button in Power BI to drill through.

I have an Esri map showing a number of properties and I have a button that becomes active when a property is selected and allows the user to drill-through to another page to view property details.

This will be a publicly accessible report and it's unlikely that most users will understand what drill-through means or even to right-click.

AnthonyLatini
Esri Contributor

@hgaignard @BrettMartin1 - Thank you for reaching out on this issue! 

Because of the complexity of this update, there is a chance that there is something cached in the WebView2 and Cache folders in Power BI Desktop and in Power BI Online. This error when signing in is caused by the cache. Please run through the following steps to clear the cache. 

ReferenceClear the browser's local storage—ArcGIS for Microsoft 365 | Documentation

  1. On your local system, depending on how you installed Power BI, browse to one of the following folder locations:
    • .exe version—%LocalAppData%\Microsoft\Power BI Desktop (for example, <user>\AppData\Local\Microsoft\Power BI Desktop)
    • Microsoft Store version—C:\Users\<user>\Microsoft\Power BI Desktop Store App

  2. Delete the CEF folder.
  3. Delete the WebView2 folder.
  4. Delete the Cache folder.
  5. Restart your machine.

 

AnthonyLatini
Esri Contributor

@BrettMartin1 - I apologize for the inconvenience that the update has caused for your reports. For this update, we had to make some changes to how we process the Table of Contents and the technology that was being used. 

To satisfy both the technology requirements and the multiple requests for a Legend on the map, we did our best to cover any and all scenarios where the Table of Contents were docked to the report. The Table of Contents in previous versions was meant to run as a pseudo-legend; which didn't really achieve what a true legend does from a GIS/cartographic standpoint. 

In this update, we've now given users more flexibility to have either a Legend or the Table of Contents depending on the content of the map and how the report was generated. 

To reiterate, I apologize for the disruption this has caused. For future updates, we will be better about upcoming changes to the components. Thank you for the feedback! 

AnthonyLatini
Esri Contributor

@Roland_at_Planet - I have posted in this thread for a bit more information. Thanks! 

Reference: Re: Drill button not working with last update from... - Esri Community

RodPBI
by
Regular Contributor

MY initial impression is WOW!!  Fantastic job!  Thank you.  Very excited to test it out with some report users.

NeilWarren2
Occasional Explorer

Where can I add dynamic color values instead of having to choose from the default color ramps?  This was an option in the previous version and was easy to set up. 

EileenTeasdale
Emerging Contributor

@AnthonyLatini  - I also had the same error as hgaignard and we (our IT dept) cleared my cache as per your solution and it worked. This was maybe a month ago.  However I have since opened up my PowerBi report and the issue has reappeared.  I do not want to constantly every month I work on my reports and have to clear my cache to resolve this issue on my reports?  Why does it seem to continually do this.  Is there someone who can contact us to get this resolved.  

ar_tw
by
Emerging Contributor

Support the update - but like others, this has broken production reports, which doesn't give our users confidence in the system.

I'm not the PowerBI admin - but as I understand it - the visual auto updated, in a version of PowerBI that it's not compatible with - so we now need to upgrade PowerBI ReportServer in multiple environments (Dev, then Test, then Prod), before we can begin rebuilding and republishing our reports.

KevinF_hps
New Explorer

Thanks for the update - the UI/UX changes were much needed to make it look more modern and the join & legend features are great additions.

I wanted to note an issue that was mentioned in this post.  Dates in tooltips appear as only numbers (date epochs, maybe?) rather than how the date should be formatted (2024-09-25, etc.).  Hopefully it can be fixed for the next release.