topic Re: ArcGIS GIS in PowerBI sign in button does nothing in a published dashboard in ArcGIS for Power BI Questions

ArcGIS GIS in PowerBI sign in button does nothing in a published dashboard

Bloomers3166 — Tue, 09 Jul 2024 23:45:37 GMT

Hi,

We are currently facing an issue with logging in to access a map in our published Power BI dashboard, which is powered by ArcGIS for Power BI. Up until last week, everything was working fine. However, it seems that the latest update to ArcGIS for Power BI might have caused connection issues.

When users of the published dashboard attempt to sign in to access the map in enterprise mode, clicking the button does not initiate any action.

Clearing the cookies, is the current workaround as posted in: https://community.esri.com/t5/arcgis-for-power-bi-questions/issue-with-gis-map-on-power-bi-since-the-user/td-p/1499949

The map works for one day and then when users open the dashboard the next day the button does not work again.

It would be a hassle, to tell users to clear their cookies every day just to access the map. Any thoughts on how to resolve this? Thank you.

We're using Enterprise 11.2

Re: ArcGIS GIS in PowerBI sign in button does nothing in a published dashboard

AnthonyLatini — Wed, 10 Jul 2024 01:32:39 GMT

Hello @Bloomers3166 ! Thank you for reaching out about this issue. I apologize for the inconvenience that this is causing.

I had a look at this workflow, and I am unable to reproduce the issue on my end. I am using Enterprise versions 11.2 and 11.3 to attempt and reproduce it.

Just to confirm: are you publishing the report or embedding the report? In a published scenario, there should be no sign in dialog whatsoever. In an embedded scenario, you will see a blocking page to sign in if the map contains private data. Lastly, what data is on the map? For my tests, I am using XY values, a public reference layer, and a private reference layer.

Let's see if we can get this sorted out! Thank you!

Re: ArcGIS GIS in PowerBI sign in button does nothing in a published dashboard

Bloomers3166 — Thu, 11 Jul 2024 13:10:19 GMT

Hi @AnthonyLatini,

Thanks for taking the time to look into this. We're using 11.1, my bad.

Just to confirm: are you publishing the report or embedding the report?
-We're publishing the report to the Microsoft Power BI service (powerbi.com)

what data is on the map?
-Hosted feature layers that are shared in our organization's groups. Users need to be part of that group to view it. Layers are added using this workflow in PowerBI desktop: https://doc.arcgis.com/en/microsoft-365/latest/power-bi/add-content-from-arcgis.htm

The map in our report was added using this workflow: https://doc.arcgis.com/en/microsoft-365/latest/power-bi/create-a-map.htm

The only difference is that the symbol of ArcGIS maps for Power BI in the guide differs from our PowerBI desktop. (See image below)

The issue persists whether viewing the report in Edge or Chrome.

The issue also appears when opening the .pbix file on the Power BI desktop.

I tried creating a new map on the Power BI desktop and when it asks you to sign in to the ArcGIS account. A 'reading error' pops up. (See image below).

It is the same error as what users reported in https://community.esri.com/t5/arcgis-for-power-bi-questions/issue-with-gis-map-on-power-bi-since-the-user/td-p/1499949

The workaround to get it working in Chrome, Edge, and Power BI desktop is by following this procedure every time I restart my machine. Clear the browser's local storage—ArcGIS for Microsoft 365 | Documentation which is not ideal.

Here are the software versions we are using:
Power BI Desktop version: 2.128.952.0 64-bit (April 2024)
ArcGIS for Power BI version: 2024.1.300.0

Re: ArcGIS GIS in PowerBI sign in button does nothing in a published dashboard

First_Environment — Thu, 11 Jul 2024 17:05:35 GMT

Same issue. It was working last week - now cannot log in.

Re: ArcGIS GIS in PowerBI sign in button does nothing in a published dashboard

AnthonyLatini — Thu, 11 Jul 2024 17:25:22 GMT

No worries at all @Bloomers3166 ! Thank you for the detailed response! This helps quite a bit. One thing that I would like to do for troubleshooting purposes is to ensure you are on the latest version of Power BI Desktop. As of writing this message, the latest version is:

Version: 2.131.901.0 64-bit (July 2024)

As per Microsoft guidelines (which we follow as well), the version of Power BI Desktop should not be more than one month out of date. There have been multiple updates from Microsoft (including the update of our icon) from April to now. I am wondering if the version is incompatible with what is on Power BI Online.

Also, I would like to confirm that you do not have two versions of Power BI Desktop on your machine. In some cases, you might have the Microsoft Store version as well as the .EXE version. There can be some conflicts with updates and sending information into Power BI Online.

Ensure that you only have one version installed and that you are on the latest version. Clear the cache in both Power BI Desktop and Power BI Online and then republish the report.

Give this a try and let me know what happens!

Re: ArcGIS GIS in PowerBI sign in button does nothing in a published dashboard

AnthonyLatini — Thu, 11 Jul 2024 17:26:13 GMT

@First_Environment - Thank you for reaching out! Can you please provide additional information on this much like @Bloomers3166 has done? Particularly the version of Power BI Desktop, what is on your map, if you have cleared the cache, etc.

Thank you!

Re: ArcGIS GIS in PowerBI sign in button does nothing in a published dashboard

Bloomers3166 — Thu, 11 Jul 2024 23:14:02 GMT

Thanks for the quick response @AnthonyLatini.

As per Microsoft guidelines (which we follow as well), the version of Power BI Desktop should not be more than one month out of date.

-That is a problem. Uninstalling and reinstalling products in our organization is complicated and involves multiple departments.

Note: The issue is not only present on my machine. Four machines within our team have reproduced the same issues. I will confirm if all of them have the same versions as mine, but I assume we have the same licenses installed.

Also, I would like to confirm that you do not have two versions of Power BI Desktop on your machine. In some cases, you might have the Microsoft Store version as well as the .EXE version. There can be some conflicts with updates and sending information into Power BI Online.

-Stupid question, how do I check whether I have two versions? I only looked at add or remove programs in the system settings and only one showed in the results.

Re: ArcGIS GIS in PowerBI sign in button does nothing in a published dashboard

Bloomers3166 — Wed, 17 Jul 2024 00:34:04 GMT

Hi @AnthonyLatini

Just wanted to update you with the troubleshooting steps that I did so far.

-Uninstalled Power BI desktop
- Deleted the remaining Power BI Desktop files inside this: C:\Users\{User}\AppData\Local\Microsoft\Power BI Desktop
-Downloaded a new version (Version: 2.131.901.0 64-bit (July 2024)) of the Power BI desktop from https://www.microsoft.com/en-us/download/details.aspx?id=58494

The issue as expected was fixed for two days and then it returned. The sign-in button is still not responding and when creating a new map element, the 'reading error' still pops up.

Thoughts on how should I proceed?

P.S. I also checked and confirmed that I have only one version of Power BI Desktop

Re: ArcGIS GIS in PowerBI sign in button does nothing in a published dashboard

BrianB — Thu, 18 Jul 2024 20:32:49 GMT

We are experiencing the exact same issue 5 users currently reporting this with both the June and July releases. We only have a single version installed on each laptop. We have tried the clear profile workaround, that did not work. We have even deleted to folder from the profile and un-installed and re-installed the software again with no luck. We also have issues with external facing Enterprise Portals that we have. We can however connect to our Live and Test internal Portals. We have checked our proxy servers and VPN, they are not effecting the issues as we can turn these off and go direct and still have the issue with AGOL and our external portals.

Re: ArcGIS GIS in PowerBI sign in button does nothing in a published dashboard

First_Environment — Mon, 29 Jul 2024 17:03:12 GMT

This has been an issue since the latest update. The workaround noted in Clear the browser's local storage—ArcGIS for Microsoft 365 | Documentation (local storage of PBI) does help to log in but requires performing the workaround every few days.
We are using Version: 2.131.1203.0 64-bit (July 2024)

Re: ArcGIS GIS in PowerBI sign in button does nothing in a published dashboard

KyleGardner — Tue, 30 Jul 2024 14:01:06 GMT

Hi @AnthonyLatini

Seeing the same issue in PowerBI Desktop, button does nothing when clicked. What is the official fix for this in the end or is there not one yet? As others have said, this has only occurred after the recent large update to PowerBI in ArcGIS.

Thankyou.

Re: ArcGIS GIS in PowerBI sign in button does nothing in a published dashboard

soyo — Wed, 31 Jul 2024 01:10:34 GMT

Hi there to log in you must choose the URL option

In the next screen enter your organisation account URL even if it is AGOL

After signing with the credentials the settings to validate (scrooll down)

Re: ArcGIS GIS in PowerBI sign in button does nothing in a published dashboard

LeslieUK — Wed, 31 Jul 2024 10:26:14 GMT

Hello @KyleGardner

I believe this issue has to do with the browser as this should be the underlying tech for the pop-up - specifically the WebView2 component that gets installed automatically with it.

I have seen issue resolved by uninstalling this and then reinstalling this component from: Microsoft Edge WebView2 | Microsoft Edge Developer using the Evergreen Standalone Installer.

That normally does the trick. Also, clearing your browser cache after a reinstall of Power BI resolves this kind of issue as well: Clear the browser's local storage—ArcGIS for Microsoft 365 | Documentation

Re: ArcGIS GIS in PowerBI sign in button does nothing in a published dashboard

FloraAdekola — Wed, 07 Aug 2024 08:32:46 GMT

Hi, I had the same issue as well. I think it's due to the recent updates. A lot of other users have been complaining.

This worked for me, so feel free to try:

On your local system, navigate to the following 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
Delete the CEF folder.
Delete the WebView2 folder.
Delete the Cache folder.
Restart your machine.

Re: ArcGIS GIS in PowerBI sign in button does nothing in a published dashboard

AbdulHassan — Wed, 07 Aug 2024 18:42:28 GMT

Hello,

I've been having this issue as well. Another problem is in the Power BI Service (not desktop) you need to continuously remove cookies for the report to work properly. Also I have end users that view the report that can't get it to work either way. Has there been a solution to this issue posted yet? Thank you.

Re: ArcGIS GIS in PowerBI sign in button does nothing in a published dashboard

SarahGaffney — Tue, 13 Aug 2024 03:54:13 GMT

Hi,

I have followed all of the available workarounds and steps noted above and I am still getting the same error. Is there a permanent solution as yet?

Re: ArcGIS GIS in PowerBI sign in button does nothing in a published dashboard

SarahGaffney — Tue, 13 Aug 2024 04:37:31 GMT

I finally got it to work - the URL is now case sensitive, it was not before. Copying and pasting the url from the address bar resulted in as issue, but adding a capital at the beginning of the company name worked for me

Re: ArcGIS GIS in PowerBI sign in button does nothing in a published dashboard

Bloomers3166 — Mon, 09 Sep 2024 03:46:30 GMT

Hi Everyone,

Just a quick update on what happened on our end. Our problem ended up being a bug (BUG-000169456) so we had no choice but to put warning messages with links to the dashboard on how to clear cookies for our users to get the ArcGIS for PowerBI map working every time they need to use it.

Lately, the problem disappeared for some reason. I'm not sure though if it was because of the latest update of PowerBI. Maybe updating would resolve the issue for people who have the same problem as us.

Current PowerBI Version: 2.131.1203.0 64-bit (July 2024)
Current ArcGIS for PowerBI Version: 2024.1.300.0