John Fuhrman on 16 Aug 2018 01:54:36
As Power Bi and other applications in the Power Platform become more prolific within the BI Cloudscape and Landscape integration, gateways will become used more and more. Having visibility to the capacity of a gateway, the volume of traffic through the gateway, which datasources are used more frequently than others, which types, etc would be a very useful resource to have within the Gateway management system.
- Comments (18)
RE: Gateway Usage monitoring tools for Power BI Service
In addition to this, allowing multiple administrators to manage and change an individual dataset's refresh schedule would be essential. Right now we have two people that share the responsibility of managing datasets and if my partner sets a schedule, not only can't I edit the schedule, but I can't even view the schedule. Unless I take over the schedule, in which case my partner then can't view it, so it becomes a constant tug of war over the schedule ownership, making keeping track of them difficult (or relegated to an Excel spreadsheet). At least I can still view the history, but I have to go to each individual dataset, which is another area where this overview would be handy.
RE: Gateway Usage monitoring tools for Power BI Service
Usage Report for Enterprise Gateway - The log data should be available so that we can create dashboards based on Gateway Usage data.
Metrics like the datasets name using Gateway, workspace name, owner, scheduled refresh frequency, adhoc refresh, run duration and other parameters for all dependent reports should be available. This will help in scaling the Enterprise Gateway correctly and avoid bottlenecks. Currently there is no visibility to the work spaces for which we don't have access however responsible for maintaining gateway.
RE: Gateway Usage monitoring tools for Power BI Service
Yes, I want to analyze all On-Premises Data Gateway in our organization,
Which one need more performance about CPU, Memory?
Which one need more availability by adding a node?
Which one need more node for load balancing?
RE: Gateway Usage monitoring tools for Power BI Service
It would be very interesting to have the option to see the activity carried out through the gateway in the Power BI service, so that it can be seen in a simple way, the actions of updating the data sets that has been carried out from a gateway / connection, by way of the update history of the data sets but from the administration of the gateway.
Regards
RE: Gateway Usage monitoring tools for Power BI Service
Agreed, it would be nice to have a page dedicate to all the datasets and refresh schedules in order to better manage them. Once the number of datasets grows, it becomes more time consuming to keep clicking into each dataset in order to view their status.
RE: Gateway Usage monitoring tools for Power BI Service
When you have multiple data sets set to Schedule Refresh across multiple workspaces it can quickly become difficult to keep track of what is scheduled to run when. It can also become difficult to manage older versions of reports that no longer need to run, and ensure only what is required is scheduled.
Other BI tools have a screen where you can see and manage all scheduled refreshes in one place. Without this some companies many struggle to replace other tools with Power BI.
RE: Gateway Usage monitoring tools for Power BI Service
We use a scheduled powershell script that will 'alerts' us if the gateway service is not running. However, we have had instances where the gateway service is running but not responding. When trying to restart the service it gets hung in a "stopping" status. We have to use these commands to force stop the service then restart it again:
sc queryex PBIEgwService
taskkill /f /pid [PID]
Note: the PID comes from the sc queryex PBIEgwService command
RE: Gateway Usage monitoring tools for Power BI Service
We have to keep on monitoring at regular intervals which is difficult. It would be good if we get notification from cloud if gateway goes offline.