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.
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.
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.
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.