I’m reaching out due to frequent issues with extremely slow download times when refreshing our Power BI reports based on Visma.net.
The main bottleneck seems to be the JournalTransactionLines table, which often gets stuck with the message “Waiting for bridge online-cloud.” While refreshes occasionally complete within a few minutes, it’s more common for them to take 30-60 minutes-or fail entirely. Interestingly, another table, supplier invoices lines that also contains a lot of data may load much faster.
We’re a relatively small company, and our journal transaction lines dataset is only around 100MB, which we didn’t consider to be unusually large. Unfortunately, the current refresh performance is not acceptable for our reporting needs. If this cannot be resolved, we will need to consider alternative solutions.
I’d appreciate your input on how this can be improved.
Details can be found by clicking on the download request which represents the issue discussed in this topic.
Please leave at least the following data visible:
the title bar with the request ID,
the status code, network size and times in the left column,
the error code and error message at the very bottom of the left column,
the entire right column including the SQL statement, table name and parameter values.
Check user
Check carefully that you are logging into the Bridge Online website that is also used from Power BI. You will only see the requests from the user you are logging into the website with.
Error message and tips per email
In addition, the Invantive Cloud user who has the error message will usually receive on his email address an email with an error message and tips if there is an error message in Power BI, Power Query, Azure Data Factory, Qlik or Tableau.
Advice is to check the affected user’s spam for such emails sent from support@invantive.com.
But as you can see the Visma JournalTransactionLines view never completes. It just goes on and on, with the message “waiting for bridge online cloud”. The refresh preview of 1000 rows works fine. However I am not able to load the entire data set.
I am also reauthorized the database container, so that shouldnt be an issue.
Can we talk about this over Teams? I have struggled for some days now, and I urgently need to complete our financial reporting.
Update, the refresh was cancelled and I got these error messages in Power BI, but I am not sure what the root cause is.
VismaNet Views JournalTransactionLines@vnt
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.
Calendar
Load was cancelled by an error in loading a previous table.
VismaNet Account Accounts@vnt
Load was cancelled by an error in loading a previous table.
Transaksjoner konsolidert
Column 'Rapporteringperiode' in table 'Rapporteringsperioder' cannot be found or may not be used in this expression. OLE DB or ODBC error: [DataSource.Error] OData: Request failed: The remote server returned an error: (502) Bad Gateway. (Bad Gateway).
CustomersSuppliers
Load was cancelled by an error in loading a previous table.
Causal
Load was cancelled by an error in loading a previous table.
MeasureSelection
Load was cancelled by an error in loading a previous table.
MeasuresTable
Load was cancelled by an error in loading a previous table.
KPIs
The value for 'Ord GP AC' cannot be determined. Either the column doesn't exist, or there is no current row for this column. The value for 'Ord GP Plan' cannot be determined. Either the column doesn't exist, or there is no current row for this column.
Rapporteringsperioder
Load was cancelled by an error in loading a previous table.
Period Calculation
Load was cancelled by an error in loading a previous table.
Opening balance
Load was cancelled by an error in loading a previous table.
SupplierInvoiceLines
OLE DB or ODBC error: [DataSource.Error] OData: Request failed: The remote server returned an error: (502) Bad Gateway. (Bad Gateway).
Query parameters
PERSONAL_ACCESS_TOKEN
Load was cancelled by an error in loading a previous table.
BASE_ID
Load was cancelled by an error in loading a previous table.
TABLE_ID
Load was cancelled by an error in loading a previous table.
Parameter1
Load was cancelled by an error in loading a previous table.
Cl
Thanks for the information. The messages here are from Power BI and do not provide any context or information. An analysis will be done regarding the request from the picture and then added.
Error text: The data download was cancelled after 8 minutes, 50 seconds, such as by the user navigating away in the Power BI or Power Query user interface. Please optimize your query as described on https://go.invantive.com/en/power-bi-tuning. Then re-run the query.
In the tab Phases on Invantive Bridge Online Monitoring the following will be visible:
Could not acquire free slot on throttle ‘ThrottlingBasedOnLicense’ for cap group ‘lic:L979259370’ after waiting since 04/09/2025 07:51:16.
or
Other requests are currently taking up all available slots on the subscription. Wait till another request finishes, optimize your requests or upgrade the subscription. There are 4 requests waiting to be served.
The requests have all gone from memory by now. This problem might be related to a problem itgentmm007, but that can not be established at the moment.
It is recommended to retry the download. When it fails or succeeds, please update this topic.
In case it is related to the itgentmm007 error: for this an analysis and improvements are on their way. There are also currently issues with handling an increased volume of traffic. For this, changes have already been taken into production on the French datacenter of an European owner (the Amazon datacenter will not be used anymore for the frontend servers to improve digital sovereinity or compliance with GDPR; the remaining backend servers are also being migrated).
In case the problem resurfaces, please append to this topic or create a new one.
The problem is back. I am not able to refresh the data.
During monthly closing and financial reporting I need to be able to refresh the reports multiple times a day without spending a lot of time waiting for the refresh to complete, or not complete at all.
The refresh process appears to be very unreliable unfortunately, and I cant continue like this.
Details can be found by clicking on the download request which represents the issue discussed in this topic.
Please leave at least the following data visible:
the title bar with the request ID,
the status code, network size and times in the left column,
the error code and error message at the very bottom of the left column,
the entire right column including the SQL statement, table name and parameter values.
Check user
Check carefully that you are logging into the Bridge Online website that is also used from Power BI. You will only see the requests from the user you are logging into the website with.
Error message and tips per email
In addition, the Invantive Cloud user who has the error message will usually receive on his email address an email with an error message and tips if there is an error message in Power BI, Power Query, Azure Data Factory, Qlik or Tableau.
Advice is to check the affected user’s spam for such emails sent from support@invantive.com.
Details can be found by clicking on the download request which represents the issue discussed in this topic.
Please leave at least the following data visible:
the title bar with the request ID,
the status code, network size and times in the left column,
the error code and error message at the very bottom of the left column,
the entire right column including the SQL statement, table name and parameter values.
Check user
Check carefully that you are logging into the Bridge Online website that is also used from Power BI. You will only see the requests from the user you are logging into the website with.
Error message and tips per email
In addition, the Invantive Cloud user who has the error message will usually receive on his email address an email with an error message and tips if there is an error message in Power BI, Power Query, Azure Data Factory, Qlik or Tableau.
Advice is to check the affected user’s spam for such emails sent from support@invantive.com.
This question was automatically closed after at least 1 week of inactivity after a possible solution was provided. The last answer given has been marked as a solution.
Please ask a new question via a separate topic if the problem occurs again. Please include a link to this topic in the new question by pasting its URL into the text.