Skip to main content

Power BI

Needs Votes

Gateway Usage monitoring tools for Power BI Service

Vote (340) 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.

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

70ed0d96 69ea-4bdb-a170-9cc839f05c9d 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

ec8db890 afd2-4392-a994-2f6055f221d3 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

911e7fd6 2daa-44b2-a1a7-66d811e51380 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

96c9d524 b699-45cb-9116-6e8447b7d3a7 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

702f37b8 4325-e711-8121-e0071b66ae51 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

2b235705 04fc-4ad6-847f-5e09a495ae4f 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

6e8592d8 0ed6-4dc1-bc8d-3c6abf353dee 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

a3309361 99be-ea11-a812-000d3a8ddfb2 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

0691134d 4862-4acf-a4b7-ab519738e76c 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

a3309361 99be-ea11-a812-000d3a8ddfb2 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!