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:
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:
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.
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.
Select Use to specify whether to retrieve data from the company.
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.
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?
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.
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?
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.
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:
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.
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.
Select Use to specify whether to retrieve data from the company.
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.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
