Power BI
NewUser would like to understand how to optimize and monitor capacity usage by vnet gateway
Srusti Shetty on 07 Aug 2024 07:58:14
Here User have a query as below:
They have downloaded the detailed report in PowerBI report created from parquet files downloaded from Virtual Network Data Gateways for the vnet gateway, and they can entry consuming majority of their capacity, there is Query ID field in that report.
They want to understand how to recognize particular report/query/connection in PowerBI, based on that information (or any other ID available in the report)?
Also, they would like to know, which queries are consuming most of the capacity, to be able to optimize them.
Ask: How to recognize the particular query and optimize them?
- Comments (1)
RE: User would like to understand how to optimize and monitor capacity usage by vnet gateway
We need to be able to decide the corrective action to take on problematic reports over-consuming CUs. There is a total usage report but is ambiguous as the report only calculates based on the capacity ID (instead of the total usage of the system). Basically requiring the user to run the report for all the capacity ID's they own and manually add the data together.A better option will be to have the report look at the entire tenant, and group by Capacity, Workspace and then report.