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:
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)
The request is executed using the credentials provided, so in general it is best to use the same account as used to run the requests, since otherwise no data will be visible.
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.