Skip to main content
Microsoft Idea

Power BI

Planned

Gateway Usage monitoring tools for Power BI Service

Vote (360) Share
John Fuhrman's profile image

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.

Administrator on 08 Dec 2020 18:28:56

Moving status to Planned, as we are working on this.

Comments (18)
John Fuhrman's profile image Profile Picture

Alex Robé on 06 Jul 2020 00:10:55

RE: Gateway Usage monitoring tools for Power BI Service

In case of having multiple datasets in variable sizes up to multiple 100 of MB we sometimes face refresh issues, that relate to simultaneous / overlapping refreshes of datasets, causing "usually transient" issues.
If we have an easily accessible chance to find empty time slots we could balance the gateway better.

Dreaming allowed? Using a Gantt Chart visual showing runtimes of each dataset :-)

John Fuhrman's profile image Profile Picture

Thomas on 06 Jul 2020 00:00:05

RE: Gateway Usage monitoring tools for Power BI Service

This is essential for administration, especially to avoid duplicate connections, inactive connections, tracking the users in that connections etc.

John Fuhrman's profile image Profile Picture

Joshua Cameon on 05 Jul 2020 23:47:56

RE: Gateway Usage monitoring tools for Power BI Service

Yes this would be very helpful to organizations that have a lot of import or mixed query-type reports. Either by Gateway or workspace or even overall as an organization high-level would be great use.

John Fuhrman's profile image Profile Picture

Power BI User on 05 Jul 2020 23:45:36

RE: Gateway Usage monitoring tools for Power BI Service

Need to be able to monitor health of refreshed dashboards and troubleshoot if necessary. From time to time a dataset will successfully refresh with zero rows due to operational issues. Can additional dataset refresh metadata be made available to give visibility?

John Fuhrman's profile image Profile Picture

Therese therese.devine on 05 Jul 2020 23:45:32

RE: Gateway Usage monitoring tools for Power BI Service

We need better/more enterprise tools for IT to SUPPOT all of BI; especially the disabled gateway refreshes after a connectivity/ server issue. We are supporting 30+ workspaces and that is growing every day. When the schedule report refreshes are automatically disabled we have to manually access each workspace, each report etc. to turn the refresh back on. We need enterprise views to support and fix issues like this across all of our workspaces, gateway tools etc. to review total space utilization etc.

John Fuhrman's profile image Profile Picture

Chris Amore on 05 Jul 2020 23:44:32

RE: Gateway Usage monitoring tools for Power BI Service

This type of monitoring, along with error reporting, is a much much needed component of this product.

John Fuhrman's profile image Profile Picture

Rob on 05 Jul 2020 23:42:59

RE: Gateway Usage monitoring tools for Power BI Service

It would be very useful to have gateway usage reports that are similar to the report usage reports. Specifically seeing a list of all reports being refreshed through a specific gateway cluster, which gateway within the cluster is being used, the refresh times, and other relevant resource metrics (e.g. RAM usage, overall RAM consumption throughout time, network throughput, amount of data written)

John Fuhrman's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:41:40

RE: Gateway Usage monitoring tools for Power BI Service

It is a must to support organisms with an important Power BI infrastructure

John Fuhrman's profile image Profile Picture

DT on 05 Jul 2020 23:41:40

RE: Gateway Usage monitoring tools for Power BI Service

Really like this idea for any serious organization, this would bring PowerBI to the next level

John Fuhrman's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:41:39

RE: Gateway Usage monitoring tools for Power BI Service

'We need ability to monitor gateway refreshes in real-time:
-have an overall view of what's running right now: datasets, workspace, gateways, memory, CPU. We have it in the PBI capacity metrics, but only, the day after that is not helping for live monitoring.
-ability to cancel a refresh when it has started
-use past stats to provide some ETA on refresh currently running, and provide a way to display that ETA on a report
-see the "true" current state (not just the wheel running) often it's broken but we see the error only 2 hours after
Thanks!