If your Power BI report doesn’t look the way you expect them to, you can make some adjustments to the report.
Only load data for the period you’re reporting on
The Auvik template asks you to enter a reporting period.
When selecting which dates to include in your report, make sure to be as precise as possible. For example, if you’re generating a report about a single month, only report from the first day of the month to the last day of the month. Every extra day of reporting can impact your report, especially if you have a lot of accounts or devices under management.
Remove reports, charts, or databases you’re not using in a specific report
Auvik’s master template has all reports available in a single template file.. As you start using these reports, you may find that you never use the reports together.
One easy way to optimize your report performance is by creating copies of the main template that only contain the specific report(s) you are using together.
For example, you may be using Auvik’s out-of-the-box QBR (quarterly business review) and device performance reports together when you’re sharing quarterly reports to your customers. You may also be sending weekly NOC reports to a specific group of users and while also using the inventory management report internally. In this scenario, you can save three different templates: One template for QBRs, one template for weekly NOC reports, and one template for internal reports.
To optimize these reports, you need to remove all unused components from each report. You can safely delete these specific items:
- Unused report tabs
- Unused charts
- Unused data fields
Note: Deleting unused data fields should be a last resort. There are some data points that aren’t being used in the charts or reports but are relevant to the data model. Fields that can comfortably be deleted if they’re not being used are:
- Bandwidth
- Device metrics (CPU, memory, storage)
- Packet related metrics (multicast, unicast, broadcast)
- Outage and uptime
As a general rule, avoid deleting anything related to the following data fields:
- Device inventory
- Alerts
- Tenants
- Date
- Time
Also avoid deleting any columns that are in use in the Manage Relationships tab as they’re being used for correlating with other data points.