Since this weekend, our data from Exact Online is no longer refreshing.
In Power BI Service, I’m not getting enough explanation as to why the data isn’t being retrieved.
Can someone check why this is happening?
Additional information
Is it possible to add a (anonymised) screenshot of the details of the request in Invantive Bridge Online Monitoring, as described in Meer inzicht met nieuwe Online Monitoring?
You will find the details by clicking on the download request which represents the subject of this topic.
The download request usually has an SQL statement in which the table name is visible.
Please leave at least the following information visible in both columns:
- the title bar with the request ID,
- the status code, network size, path and timestamps in the left-hand column,
- the error code and error message right at the bottom of the left-hand column,
- the entire right-hand column, including the SQL statement, table name and parameter values.
For example:
Check the correct server and user
Please check carefully that you are logging in to the Bridge Online website that is also used from Power BI, and with the same username. You will only see the requests from the Invantive Cloud user with which you log in to the website.
There are four servers in use:
bridge-online.cloudapp-online.cloudbridge-online.invantive.comapp-online.invantive.com
You can see which server is being used in your script or report source code.
Check the correct request and details
Make sure you select the request first in order to display the details. Only one request should be visible in the screenshot.
Also check carefully whether the request has a path with odata4 or apps. Requests with other paths are generally not relevant for this purpose.
Error message and tips by email
In addition, the Invantive Cloud user who received the error message will usually receive an email at their email address containing an error message and tips, if there is an error in Power BI, Power Query, Azure Data Factory, Qlik or Tableau.
Our advice is to check the spam folder of the user concerned for such emails sent from support@invantive.com.
The itgenlic754 error message occurs if a subscription has access to more Exact Online administrations than permitted under the subscription type. Several checks are used for this.
An adjustment by Exact Online at around 20:00 on 16 January 2025 improves the check. A number of subscription holders appear to need a different subscription type.
An analysis is currently being carried out to further investigate the issue and provide a solution.
The subscriptions concerned have been converted to a different form that allows use with more than 1,000 administrations.
This question was automatically closed after 1 week of inactivity. The last answer given has been marked as the solution.
If the problem occurs again, please ask a new question via a separate topic. Please include a link to this topic in the new question by pasting its URL into the text.