topic Re: Pass through Auth not working properly in ArcGIS for Excel Questions

Pass through Auth not working properly

DougBrowning — Thu, 21 Aug 2025 22:01:55 GMT

I made a AGOL org map that has layers in it from a Portal. In map viewer this causes a brief prompt where the user has to click ok on load and then the pass through windows auth works.

But this same map in ArcGIS for Excel I get the portal prompt with a required username and password. We do not even have usernames and passwords it is all windows pass through. So then I am stuck.

Is this a bug? Is there a way around it? Seems like pass through with just the ok box is not there.

If I instead make the map in the portal I still have the same issues with our state users since they are in a different portal and has to also pass through to our central portal.

thanks hope that makes sense

Re: Pass through Auth not working properly

ShannonCardoza — Thu, 28 Aug 2025 17:26:20 GMT

Good morning @DougBrowning, Thank you for posting your inquiry. After working with my colleague on this, it appears if you are using Enterprise IWA (Windows oAuth) machine. Can you confirm?

I have AGOL map containing a layer from Portal (I am using 11.5 Enterprise IWA portal machine). When I open map containing Portal layer in AGOL it was added automatically I don't have to click any OK button or sign in again. My experience differs from yours. Can you confirm what versions you are using?

Best,

Re: Pass through Auth not working properly

DougBrowning — Thu, 28 Aug 2025 19:46:39 GMT

The map is in AGOL but the service in the map is from Portal 11.3. Yes windows pass through. In the web map we get a popup that is just an Ok, click and in. Excel always asks for un and pass. We test it this way since we have one portal per state. So the user will always be in a different portal than the layer and map.

Hope that makes sense. thanks

Re: Pass through Auth not working properly

ShannonCardoza — Fri, 29 Aug 2025 20:15:30 GMT

Good afternoon @DougBrowning,

Thanks for the additional information. After sharing these details, my colleague was able re-verify using the same version of Portal (11.3) as you. We were able to reproduce the endless looping so we have asked our Dev team to research further. A notable mention, if you can upgrade to 11.5, the issue doesn't seem to be appearing. Not sure if that is something that is possible.

Stay tuned...

-SC

Re: Pass through Auth not working properly

ShannonCardoza — Wed, 10 Sep 2025 16:29:59 GMT

Good morning @DougBrowning,

Hope all is well. I wanted to provide an update regarding the reported bug you experienced. This will be fixed in our upcoming release, scheduled mid October 2025.

Please let me know if you have any other questions or concerns.

Best,