Being considered somewhat of an expert with Jet Reports, I was asked for assistance by a colleague who was configuring Jet Reports for a client; they had installed the extension and were trying to create a data source for accessing Microsoft Dynamics 365 Business Central, but were receiving an error message every time they tried to connect:
Jet Reports
Invoking the web service failed with the following message:
The remote server returned an error: (401) Unauthorized.
When they first asked me for help with logging into the data source, before they showed my the error message, I assumed it was the issue where you need a Microsoft 365 admin to log in first, but the error message they then shared is not that.
The problem here is that the consultant was trying to log into the data source using their own company email account, which meant that they were not being authorised correctly against the clients environment.
when you configure the data source, there is the “optional” field of Dynamics 365 Authentication Tenant; this field is optional if you’re logging in with an email address on the same Microsoft 365 tenant as Business Central, but for a consultant sing their own company email address, this field is mandatory otherwise the authentication tenant is their own and attempts to log in will fail:
Once the authentication tenant GUID of the Business Central tenant was entered, the consultant could log into the data source with no further error.
What should we write about next?
If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.
