topic Re: Data from ArcGIS Portal Not Loading in Excel in ArcGIS for Excel Questions

Data from ArcGIS Portal Not Loading in Excel

PatrickMcKinney99 — Wed, 27 Mar 2024 17:51:35 GMT

I have signed-in to ArcGIS for Excel using my ArcGIS Enterprise account. I am able to see layers that can be added to the map in Excel. However, whenever I click to add one, the layer does not load. The add icon (circle with plus) just keeps spinning (see attachment).

I am able to add data when signed into ArcGIS Online. We have configured allowed origins, trusted servers, and other security settings in Portal Admin and ArcGIS Server Admin, according to Esri's best practices.

I wasn't sure if this issue is because we need to add a security setting to allow Maps for Excel to access the data?

Re: Data from ArcGIS Portal Not Loading in Excel

ShannonCardoza — Mon, 08 Apr 2024 19:43:55 GMT

Thank you @PatrickMcKinney99 for sharing. Let me complete some research and initial testing. I will reply here. Stay tuned!

Best,

Re: Data from ArcGIS Portal Not Loading in Excel

HARTerra — Wed, 29 May 2024 21:56:40 GMT

Was there ever a solution or resolution to this problem? I am having the exact same issue.

Re: Data from ArcGIS Portal Not Loading in Excel

ShannonCardoza — Thu, 30 May 2024 18:28:04 GMT

@HARTerra Hey there! I believe there was. Let me dig around and find out. Stay tuned...

Re: Data from ArcGIS Portal Not Loading in Excel

johnjcarter — Sun, 07 Jul 2024 23:54:53 GMT

I'm also getting this Failed to fetch error. The coordinate system is a projected national system (2193 NZTM), however, that should not be a problem, as I am able to choose an NZTM basemap. The layers are properly shared and feature services. I tested adding ArcGIS online layers through the same connecting and they work. I tried with both layers with and without attachments enabled.

Re: Data from ArcGIS Portal Not Loading in Excel

ShannonCardoza — Mon, 08 Jul 2024 18:11:26 GMT

@johnjcarter Good morning,

If memory serves me correctly, this original issue from this post was fixed by changing a portal security setting and was layer-specific. Are you using Portal and Online? Also have you tried the same workflow but with a different dataset?

Thank you kindly,

Re: Data from ArcGIS Portal Not Loading in Excel

Peter_Green — Tue, 07 Jan 2025 15:31:56 GMT

Hello. We are also receiving this error when trying to access referenced feature layers from our Portal. Was there ever a solution for this? We are able to add data from ArcGIS Online and the Living Atlas but we receive the "failed to fetch" error. Thanks.

Re: Data from ArcGIS Portal Not Loading in Excel

McKinneyPatrick_PA — Wed, 08 Jan 2025 14:28:19 GMT

We were able to get the issue resolved. Below are steps we had to take:

In Portal admin, go to url: portal/portaladmin/security/config.

Next, add "https://la.arcgis.com" to the "allowedProxyHosts" property.

In Server Admin, go to URL server/admin/system/handlers/rest/servicesdirectory.

Next, add "https://la.arcgis.com" to the "AllowedOrigins" property.

Lastly, we previously used the "Allow origins" in Portal security, but removed entries due to conflicts with other platforms. So if you have domains in that list, you may need to add "https://la.arcgis.com" to that list as well.

Re: Data from ArcGIS Portal Not Loading in Excel

Peter_Green — Thu, 09 Jan 2025 07:29:23 GMT

Thank you Patrick. I appreciate the help. Those steps seem to have done the trick and we can now access our Portal content via Excel.

Re: Data from ArcGIS Portal Not Loading in Excel

ShannonCardoza — Thu, 09 Jan 2025 20:21:47 GMT

You guys are awesome, I was away and could not respond quickly @Peter_Green but @PatrickMcKinney99 for the save! Have a great week/weekend.

-SC