You’re offline. This is a read only version of the page.
2
Hey everybody,
we get the error: Error loading metadata, when me use the "Edit in Excel"-Button in the webclient.
We have the BC AAD App Registration, one for the Excel AddIn and one for Exchange Online.
But only the Excel AddIn makes the problem. The BC Server is a local on-prem server. And I try to edit in Excel from the same local network.
I enable SSL in OData, API Services, Base URL etc. Everything looks fine to me.
In the Debugger of the Excel AddIn, I get the following errors:
We`ve made everything with self-signed certificates.
Is there anyone with an idea?
Thank you!
best regards,
Robin
Hello,
We indeed receive support calls around this topic so many people agree with you this is a difficult topic. Automatic deployment is rather difficult to configure because there are multiple scenario's to think about and not all customers give their partners sufficient permissions to create an Azure AD app registration. There are also hosters on the market that hosts the VM's while others hosts the Azure AD app registrations for their customers.
There is a PowerShell commandlet that you can use as well if that makes the task easier:
learn.microsoft.com/.../new-azureadapplication
My response usually is that if you spend some time on it and deploy the scenario a few times in a test environment, you will get the design ideas behind it and it is not that difficult as it seems.
Great that you had success!
Hey Marco, thank you for your help. I've found the issue..
In our WS-Federation Login Endpoint setting on our service tear:
Yot must build the full URL, like here:
learn.microsoft.com/.../authenticating-users-with-azure-ad-openid-connect
Task 4 Step3c:
<Application ID URI> The ID that was assigned to the Business Central application when it was registered in Azure AD, for example api://44444444-cccc-5555-dddd-666666666666 or cronusinternationltd.onmicrosoft.com/businesscentral.
login.microsoftonline.com/<AAD TENANT ID>/wsfed?wa=wsignin1.0%26wtrealm=<Application ID URI>%26wreply=<Redirect URL>
But we forget the "api://" before Application ID URI. The Connection work then without problems in Excel, when all SSL certificates are installed and secure.. But you get the error with the metadata.
And you can look over it, when you look only on the example Microsoft has delivered. Because any other ID string is entered without a "api://" or something.
Yeah, sure.. When you make everything that Microsoft described, it works. I think a automatic setup in Business Central where you put your Azure AD administrator credentials in work better, than make it all by hand..
Freddy maked something for his docker PowerShell CMDlets..
github.com/.../Create-AadAppsForNav.ps1
I don't see a thing, why it don't work for a standard on-prem deployment..
But I hope.. I can help someone with this information.
best regards,
Robin
For german users: Fehler beim Laden der Metadaten
Hello,
You can verify the configuration of the Excel Add-In via this url (at least you can see what it is expecting to be):
<<PublicWebBaseUrl>>/OfficeApps/Public/ServerConfiguration
E.g.
http s : // nav.domain.com/Instance/OfficeApps/Public/ServerConfiguration
The PublicWebBaseUrl is a setting to be configured in the CustomSettings.config file. The PublicODataBaseUrl should also be configured in this format:
http s : // nav.domain.com:portnumber/Instance/ODataV4/
NOTE: added a few spaces to ensure the whole string is not reformatted so that it is not clear what the contents should be
When using Azure AD authentication in an OnPrem environment, two Azure AD App registration must be created. The Excel Add-In app registration redirect uri must be of type spa (that used to be web).
Hope it helps. Alternatively, raise a request to Microsoft support and we will help you further.
Thank you.
Have you been through this setup?
Seems like there are many people that have problems with the Excel AddIn?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,134
Super User 2024 Season 2
#2
Martin Dráb
229,928
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (