ArcGIS GIS in PowerBI Web Holding Cookies

[BenHolmes1]

Hi

We're having an issue where our dashboards (published on PowerBI web) are holding the Portal for ArcGIS cookie past their expiry.

When users initially look at the dashboard with the map, it works fine.

Later on, they get the blank Visualiser with the Connect to ArcGIS button.

Clicking the button at this point has no effect.

Looking in the Chrome Developer tools, I see it gives an invalid token message for Portal. Same issue happens in Chrome and Edge.

Going into the cookies and clearing out the app.powerbi cookies is the current workaround, but we don't want to have to tell all users to do this.

Is this an issue with PowerBI/ArcGIS Maps for PowerBI or just a simple case of checking on some tickbox to force the PowerBI web app to clear the token cookie?

Regards

Ben

[Anonymous User]

Hi Ben,

When someone signs into ArcGIS from the Report, are you also checking this option to "Keep me signed in" ?

[BenHolmes1]

Hi Andrew

The Portal in question is set up to use the users AD details to log in. 

I believe it's done via SAML.

Most users will get the following prompt and then simply click the blue button.

There is an option to define the login and enter the details in the ArcGIS login section at the bottom. That does include the option to tick off "keep signed in". But like I say, most users won't even look at that. It's a workaround at best.

I need to have another look at it tomorrow.

Regards

Ben

[BenHolmes1 · Accepted solution]

Hi Andrew

We heard back from Microsoft and they suggested switching on the infrastructure update in PowerBI Desktop before publishing the dashboard.

In: File > Options and settings > Options

Then: Global > Preview features

That seems to fix it. 

[Anonymous User]

Thanks for the follow up Ben!

Our development teams met and have discussed what is included in the Infrastructure Update, and we are working through some changes to honor it once it is no longer a preview feature. We put in a fix/change that was impacting boundary matching, but this one is new to me and our team will review it.

For our next updates moving forward we will publish a list of what's included or changed in the release to GeoNet so that you can keep track and be aware when we can fully support the Infrastructure Update.

Cheers,

Andrew

[BenHolmes1]

Hi Andrew, 

One thing to note with my issue.

This is in a large client organisation, so they are still using the October 2021 version. 

I have made them aware that having the preview infrastructure features may cause other issues when upgrading to later versions. 

Can cross that bridge when they update!

Cheers

Ben

[Anonymous User]

Hi Ben,

We made some changes to accommodate for references that got changed, and it 'should' work with the infrastructure preview enabled. That said we have been seeing this in testing the February release. In theory it should work with October as well, but we have not been testing against that release of Power BI.

Please try to clear the cache, and then see if everything works with the infrastructure preview turned on.

https://doc.arcgis.com/en/power-bi/get-started/clear-browser-storage.htm#ESRI_SECTION1_E57387BD989D4...

Cheers,

Andrew

[MarkWestergaard]

I experienced the issue with the Connect button having no effect just yesterday on an existing published report. The same issue happened when I opened the report in the desktop app, which I had just worked on a couple of days ago. Clearing cookies for app.powerbi.com fixed the browser and switching off the Preview Feature "Power BI Desktop infrastructure update" fixed the desktop app. Something fishy with WebView2? I noticed an update to 2022.1.98 just this morning, but I am able to recreate the issue on the desktop with the preview feature turned back on. Power BI version is 2.102.622.0 64-bit (February 2022).

[Anonymous User]

@MarkWestergaard The issues with Preview Infrastructure are fixed in 2022.1.98. The login issue is inconsistent and we're working to identify a root cause on this one.

[BenHolmes1]

Further info

We found the switching on Preview Features, for the PowerBI (Oct 2021) version, did appear to fix the issue.

However 2 weeks later, the issue reappeared.

Basically, it looked like preview features changed the token expiry from 1 hour to 2 weeks.

Current workaround is to set Chrome to delete app.powerbi.com cookies when the session is closed.

Saves having to do that manually.

Cheers

Ben