Request failed: OData Version: 4, Error

As soon as we try to load the data into Power BI, we receive the following error:

Microsoft.Mashup.Engine1.Library.Resources.HttpResource:
Request failed:
OData Version: 4,
Error: The remote server returned an error: (500) Internal Server Error.
OData Version: 3,
Error: The remote server returned an error: (500) Internal Server Error.

Can anyone help us with this?

Additional Information

Is it possible to add an (anonymised) screenshot of the request details in Invantive Bridge Online Monitoring as described in Meer inzicht met nieuwe Online Monitoring?

You can find the details by clicking on the download request which is the subject of this topic.

The download request usually contains a SQL statement where the table name is visible.

Please ensure at least the following information is visible from both columns:

  • the title bar with the request ID,
  • the status code, network size, path, and timestamps 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.

For example:

Check Correct Server and User

Carefully check that you log in to the Bridge Online website that is also used from Power BI and with the same username. You will only see requests from the Invantive Cloud user you log in with on the website.

There are four servers in use:

  • bridge-online.cloud
  • app-online.cloud
  • bridge-online.invantive.com
  • app-online.invantive.com

The server used can be seen in your script or source code of the report.

Check Correct Request and Details

Make sure to select the request first to display the details. Only one request should be visible in the screenshot.

Also carefully check 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

Additionally, the Invantive Cloud user who received the error message will often receive an email with the error message and tips if there is an error message in Power BI, Power Query, Azure Data Factory, Qlik, or Tableau.

It is advised to check the spam of the involved user for such emails sent from support@invantive.com.

I see an error message:

itgenboe680
The database on URL segment XXXXX does not allow the use of Invantive Bridge Online.
Configure the database on Invantive Cloud.

However, we’ve already reconfigured the database via Invantive Cloud 4 times, and each time it seems to be successful.

Oh, and by the way: we’ve enabled the checkbox in the database for “Allow Invantive Bridge Online Use”.

It may be necessary to log in with the relevant user to the Invantive Bridge Online environment and perform a Reset Cache from the menu in the top right corner.