Recent ArcGIS for Power BI login issue

[MarkWestergaard]

The recent 2021.1.91 update to ArcGIS for Power BI caused a login issue for me. The visual would prompt to "login below", but there was no login form to fill. I authenticate to my Enterprise server. I saw this post regarding CORS settings, ArcGIS for Power BI Maps not loading - Esri Community. I didn't have CORS settings on my Enterprise server, but I tried adding the recommended entries. That didn't change the behavior. I removed them and the ArcGIS for Power BI visual began presenting the login form and authenticating properly.

[Anonymous User]

@MichailMarinakis1 IWA will work with the Power BI service at app.powerbi.com but it is not supported with Power BI desktop. We have an enhancement request in with Microsoft and hope to see them address this later next year. 

ArcGIS logins and SSO via SAML will work as expected.

[MichailMarinakis1]

Hi Andrew, thanks for the reply and further information about the subject. 

The only question remained for us is why we are receiving the CORS problems when we connect via the powerbi service (app.powerbi.com) to our portal?

As a workaround, I have tried to connect to our IWA portal via ArcGIS Maps for PowerBI, bypassing the webadaptor (so without SSO, using the port 7443) and then it works. Both IIS and Portal are allowing all the origins.

In general, we don't have any issues with our portal or IIS with any other application (e.g. Autocad plugin) when it tries to connect to the Portal

[Anonymous User]

IWA may work with the Power BI service at app.powerbi.com but it is not supported in Power BI desktop. We have an enhancement request in with Microsoft to support this, and hope they will look at this later next year.

[Anonymous User]

@MichailMarinakis1 IWA will not work with Power BI desktop. This is an enhancement request we have made to Microsoft on behalf of our users and we hope they will have a resolution for it this year. IWA 'may' work if you use the Power BI service, since it changes the browser component used to authenticate with Enterprise.

If IWA is required, a potential workaround... that might not be awesome, is to use Power BI Desktop to build the report with everything BUT the map. Upload to the Power BI service, then edit the report in the browser, add the map visual, then authenticate with your Enterprise. 

[GeoRSL]

@Anonymous User 
Hi Andrew, We're struggling with the same CORS issue on our browsers.
We want to use IWA with the Power BI service, but get the mentioned "blocked by CORS policy" error.

Can you tell us how you configured your portal webadaptor on IIS? Did you use the "IIS CORS module" (https://www.iis.net/downloads/microsoft/iis-cors-module)

[MarkWestergaard]

I am experiencing the issue again. I can no longer initiate a new connection from the ArcGIS Maps for Power BI visual to my ArcGIS Enterprise. The CORS Policy doesn't seem to be the culprit. Existing Enterprise connections seem to be behaving and I can connect to ArcGIS Online on new reports. The only recent change of which I am aware is I updated my Power BI desktop to the recent October release (2.98.882.0). I will compare to a coworker with an older release or I will try dropping back to an earlier release. 

[MarkWestergaard]

I'm still experiencing the issue after updating to recent Power BI 2.98.1004.0 release. I have not had a chance to drop back to a prior release, but I have tried a number of combinations in an attempt to eliminate other factors (other visuals, removing themes, etc.). This is by no means a definitive result, but I am seeing this pattern in my tests:

1. Open Power BI on an existing report that already includes the ArcGIS Maps visual. This continues to work. My existing connection to Enterprise seems to behave.
2. Open Power BI with a new report and add the ArcGIS Maps visual. No login screen appears when attempting to connect with my Enterprise server.
3. Open Power BI with a new or an existing report (with or without ArcGIS Maps visual). From the File menu, open another new report in a second window. Add the ArcGIS Maps visual to the second report. This works! The login screen appears and I can authenticate to my Enterprise server.
4. Same as #3, except open an existing report in the second window (one that doesn't already have an ArcGIS Maps visual). Add the ArcGIS Maps visual. This doesn't work.

I've been able to repeat this at least three times. Of course, the behavior could simply be specific to my desktop or configuration. One thing I forgot to mention is I am using Power BI with a "Premium per User" license, in case that is a factor.

[MarkWestergaard]

I started to wonder if this might be related to cache or cookies. I found this post and followed the steps:

ArcGIS Power BI Issues from latest release - Esri Community

It seems to have helped. I was able to open an existing report, add the ArcGIS Maps visual, and connect with my Enterprise server.

[Anonymous User]

@MarkWestergaard There was a PowerBI bug that was preventing all custom visuals from logging in. We were impacted by that and an update was pushed on the 7th or so to resolve this. Our visual was also updated on the 8th with many quality improvements. 

Please let us know if you continue to experience issues.

[DavidTreering1]

@Anonymous User You said an update was pushed on the 7th or so to resolve this.  Is this update pushed to PowerBI Desktop current installer available from Microsoft or how can I confirm I have it?