idea Please support ArcGIS Enterprise Integrated Windows Authentication in ArcGIS for Power BI in ArcGIS for Power BI Ideas

Please support ArcGIS Enterprise Integrated Windows Authentication in ArcGIS for Power BI

DavidCarpenter — Tue, 04 May 2021 19:17:01 GMT

As we very recently discovered, the ArcGIS Maps for Power BI Visualization does not support connections to ArcGIS Enterprise (Portal) where Integrated Windows Authentication has been enabled.

IWA / single sign on was one of the factors to our organization adopting ArcGIS Enterprise so to find out it won't work for Power BI users was disappointing, especially considering the use of Power BI will expose hundreds of new users to our investment in Esri technology.

Please support IWA in ArcGIS for Power BI as soon as possible so our users can seamlessly sign in.

Re: Please support ArcGIS Enterprise Integrated Windows Authentication in ArcGIS for Power BI

JonEmch — Mon, 10 May 2021 21:18:12 GMT

I have attached this idea to its corresponding enhancement: ENH-000138735 The user would like Power BI to work with IWA (single-sign-on). If you have maintenance, please log a support ticket to have your account added to this enhancement.

Re: Please support ArcGIS Enterprise Integrated Windows Authentication in ArcGIS for Power BI

DavidCarpenter — Wed, 12 May 2021 19:31:20 GMT

Thanks so much Jon! We have in the mean-time disabled single sign on so our report builders in Power BI can start to leverage Portal for ArcGIS. Once IWA is supported I can just reenable Windows Authentication in IIS on the Web Adapter machine and we should be good. As mentioned, Power BI is going to introduce the Esri technology we have in place to a whole new audience which is great. Thanks again!

Re: Please support ArcGIS Enterprise Integrated Windows Authentication in ArcGIS for Power BI

Anonymous User — Thu, 17 Jun 2021 17:47:56 GMT

Just as an FYI... there's nothing we can do within our Visual to support this in Power BI, as it is an issue with Microsoft Power BI Desktop. If you are using the Power BI service via Browser, your IWA to ArcGIS Enterprise should still work.

Re: Please support ArcGIS Enterprise Integrated Windows Authentication in ArcGIS for Power BI - Status changed to: Needs Clarification

Anonymous User — Thu, 17 Jun 2021 17:48:50 GMT

Please report this issue to Microsoft so they can make the necessary changes within Power BI Desktop to support IWA as well as PKI.

Re: Please support ArcGIS Enterprise Integrated Windows Authentication in ArcGIS for Power BI

DavidCarpenter — Tue, 22 Jun 2021 13:14:49 GMT

Thanks for the clarification Andrew, I will do just that.

Re: Please support ArcGIS Enterprise Integrated Windows Authentication in ArcGIS for Power BI

DiegoNegron — Wed, 09 Feb 2022 20:05:02 GMT

I have this issue as well. We were able to get through by bypassing the web adaptor. This will allow users to enter their login info to access the portal. Still trying to see if this issue has been resolved.

Re: Please support ArcGIS Enterprise Integrated Windows Authentication in ArcGIS for Power BI

BennyMeyns — Fri, 08 Apr 2022 14:48:10 GMT

We did some in-depth analysis on the IWA behaviour of the ArcGIS for Power BI plugin using Power BI Online (Power BI Desktop is not the focus for our users)

Our conclusion: fixing 5 lines of code in the init.js file on js.arcgis.com should fix the problem (https://js.arcgis.com/4.20/init.js).

So, their is no need for a change/fix biy MicroSoft. It's just a problem on the ESRI ArcGIS Javascript that could be easily fixed.

I'm attaching some small report together with the fixed init.js file.
Could this please be picked-up by the ESRI development team, as it really needs only a minor fix.

More information has been posted on https://community.esri.com/t5/arcgis-for-power-bi-questions/recent-arcgis-for-power-bi-login-issue/m-p/1160035/highlight/true#M1152

Of course we are availble to give you further explanation of the detected problem (by e-mail, video call, etc..)

Benny

Re: Please support ArcGIS Enterprise Integrated Windows Authentication in ArcGIS for Power BI

BennyMeyns — Mon, 26 Sep 2022 12:35:31 GMT

Hi Power BI & ArcGIS users,

We've got good news about the Power BI with ArcGIS Server integration:

Since the ArcGIS Online update of june, we've managed to use Power BI (online) and the “ArcGIS for Power BI” plugin with the IWA authentication on our ArcGIS Server layers!

Thanks a lot everybody who was helping to get this stubborn "IWA authentication" issue fixed.
Being able to combine the power of both platforms (ESRI ArcGIS + MS Power BI), will help us to level up to the next niveau!

Benny