I would like to find a solution to see what’s happening in the background when loading a data. Bridge Online Monitoring provides a good overview about the processes, and I can find out which queries are causing problems.
However I found out, that in the monitor I can see only the activities, which I started after logging in. I can’t see what’s happened in the past. So when I realize a refresh error in Power BI, I can’t see what happened.
The log is missing. I’m also curious about, if it is possible to retrevie the log in an API or from a table, and load it to Power BI?
A number of tables are available for real-time access on Invantive Bridge Online:
me on /me with current user information,
databases on /setup/databases with your party’s databases,
requests on /monitoring-api with all requests,
sessions on /monitoring-api with all sessions,
systemloads on /monitoring-api with all system load information (when made available).
All are available with basic authentication. The JSON to relational datamodel mapping has to be done by the report designer.
These tables can also easily be tested in a relational model by installing the Invantive Query Tool and then connecting to Invantive Bridge Online. Or by creating a Bridge Online database on https://cloud.invantive.com/app/setup/databases/new/bridgeonline:
Did I make something wrong on creation of the database maybe?
Additional questions:
On the screenshot provided here the server URL is https:\bridge-online.invantive.com
However when I create a new database https://bridge-online.cloud is offered. which address should I use? do I have to change this?
when registering a new database, which username and passwords should I write?
my regular username and password, or the service account’s username and password? (the traffic, what I want to monitor is authenticated in the service account)
Thank you for your reply again, very appreciate it.
