How can we help?

How to optimize your Power BI reports


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. 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request