News and Announcements icon

Dynamics 365 CommunityForums Business Central forum Edit in Excel BC20 issue

Business Central forum

Suggested answer

Edit in Excel BC20 issue

(0) Share

Report

Report

Posted on by mnitcomputerguy

22

I'm seeing a BC20 install where edit in excel isn't working. Had this working with BC19 onprem no problem.

The error is "no authentication realm is defined" yet aad authentication in the web client is working fine.

Has anyone else seen this with the edit in excel/BC20 feature?

Categories:

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 64,563 Super User on at

Like (0)

Report

RE: Edit in Excel BC20 issue

Hi, maybe it has something to do with the update below.

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/deprecated-features-platform#ws-federation-with-azure-active-directory-authentication

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/authenticating-users-with-azure-ad-overview#moving-from-ws-federation-to-openid-connect

Hope this helps.

Thanks.

ZHU
Suggested answer

Inge M. Bruvik 32,722 Super User on at

Like (0)

Report

RE: Edit in Excel BC20 issue

You need to run a setup process for this on prem, the process is documented here:

docs.microsoft.com/.../configuring-excel-addin

Hope this helps you.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 288,584 Super User

#2

Martin Dráb 225,864 Super User

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans