Skip to main content
To homepage To homepage

Hi support,

Following this ticket I will make one myself to keep things clear. 

We have set up a Business Central 365 connection, both via OAuth2.0 as service to service authentication. We have succesfully tested the connection with both authentication options. However, when we want to read objects, we receive the error “Invalid response from Business Central retrieving table Field for company”. Full log is added to this ticket as an attachment. 

We have walked through all steps from the prerequisites guide. Hence, we have a succesful connection. From the other ticket I understand that there are more versions of the Jet Analytics for Business Central extension. It has to be the newest one and I have to keep on trying. In the Extension Marketplace we only find two versions of the Jet Analytics for Business Central extension. The first from Jet Global Data Technologies is not available anymore and they point to the second; the one from insightsoftware. This is the one we have installed; version 1.23.12.3601, which seems to be the latest. How can we find out whether or not the version we use is outdated or even the wrong version?

 

For service to service authentication we have set up the Microsoft Entra Application Card permissions as follows:

 

 

Any help would be appreciated! :)

Hi @Remy Kamphuis | Victa 

Did you manage to setup all of the prerequisites?

Did you add one of the following rights to you user? Please make sure the company is set to blank

Could you also try changing the Entra application so that company is blank for D365 AUTOMATION

Did you grant consent to the application?

Did you successfully authorize Oauth?

 

Hi @Christian Hauggaard 

Thanks for your reply. I contacted the client about the suggested changes and the connection works. I am able to view the tables and fields in the connection. I can also do a preview on the data in the business unit. However, when I execute the table I don't get any rows. Any idea why that might be the case?

Hi @Remy Kamphuis | Victa 

If you preview the data in the Business Unit, does it give back any data?

You can change the Account to see if there are some that contains data.

 

Hi @Thomas Lind 

Sorry, what I meant with saying that I was able to do a preview on the table in the business unit is that I indeed are able to preview actual data there. See screenshot below. 

However, when executing this table, the data is not transferred into the ODX. 

Hi @Remy Kamphuis | Victa 

You mean if you execute a table in the business unit it is empty, or that if you run a transfer task in an BC data source made in the ODX, there is no data in there?

Hi @Thomas Lind 

Yes, when I execute the table in the Business Unit it returns empty. 

Hi @Remy Kamphuis | Victa do you have any incremental rules or data selection rules on the table?

 

Can you please try synchronizing objects for the data source and then try running a full load on the BU table?

To run a full load, right-click on the BU table and select deploy and execute

 

select Review Tasks

check the deployment steps and click Start

 

Hi @Christian Hauggaard 

There are no incremental or data selection rules applied to the table. I have ran a full load on the table but still no data is showing in de BU.

I can see data when previewing the table as shown in the screenshot above, however I cannot query the table under data sources. Can it be a rights issue? We have set up the rights according to your post above. 

They also have a data connection with an on-premise Navision database and here I can query tables in the business unit.

 

Hi @Remy Kamphuis | Victa I have created a support ticket for this

Hi @Remy Kamphuis | Victa 

We resolved this in our meeting on the 9th of October.

As far as what I saw the issue as it was that the account setup was like this.

 

The behavior is explained here.

https://legacysupport.timextender.com/hc/en-us/articles/360051368132-Microsoft-Dynamics-Business-Central-NAV-Adapter#dynamics-business-central-nav-companies

Setting Up Dynamics Business Central (NAV) Companies

When you have added a Dynamics Business Central (NAV) adapter and specified a provider, you need to set up accounts representing the companies requiring the extracted data.

To set up accounts:

  1. Right-click the Dynamics Business Central (NAV) adapter, and then click Set Up Accounts. A window is displayed that shows all companies in the database.
  2. In the Template list, select the company account you want to use as a template for the table and column structure. If you are only selecting one company, then the template company must match the company that is selected.
  3. Select Use to specify whether to retrieve data from the company.
  4. In the Default Table Usage list, specify the order in which tables are retrieved and read. You have the following options:
    Option Definition
    Primary Data from this company account is read and retrieved first
    Secondary Data from this company account is read and retrieved after the primary account if they have not already been retrieved from the primary account
    None Tables from this company are not retrieved unless you specify at the table level that you want to retrieve data from a specific table

So setting the checked account to none would make tables empty.

Reply


Terms and ConditionsCookie settings