Understanding Data Refresh Schedules in Reports

Note: If you have already been upgraded to Technology Intelligence Platform, information in this section is applicable to you. With Technology Intelligence Platform, out-of-the-box IT Visibility dashboards are being replaced with new, enhanced IT Visibility Technology Intelligence Platform reports.

Power BI provides three storage modes for tables used in reports:

• Import Mode—Power BI stores the data in its in-memory cache (pre-stored data). When rendering a visual, Power BI retrieves the data from its cache, resulting in faster performance.
• DirectQuery Mode—Data is not stored in Power BI. When rendering a visual, Power BI sends a query to the data source and fetches the data directly from the data source.
• Dual Mode—This mode allows a table to function as both an import table (cached) and a DirectQuery table (non-cached), depending on the context. In some scenarios, Power BI retrieves data from the cache, while in others, it queries the data source when additional data is required.

However, Power BI does not mix these two mechanisms. If the visual can use the cached data, all data for that visual will be retrieved from the cache. If a visual needs data that is not in the cache, Power BI fetches all the required data for that visual directly from the data source.

Aggregated measures are used to perform aggregation operation (like sum, average, min, max). When any field from the tables stored in dual mode is used either alone or in combination with aggregated measures, the data is retrieved from the Power BI cache. If all slicers and calculations are based on the stored tables, the data is also retrieved from the Power BI cache. For more information about measures, see Working With Measures.

Note:The cached data in Power BI is refreshed every 6 hours for each organization.

The following Hardware and Software tables are stored in the Dual mode:

Hardware Table

Software Table

Device Taxonomy

Software Taxonomy

Device Manufacturer

Software Manufacturer

Device Product

Software Product

Device Model

Software Release

Device Lifecycle

Software Version

Device Calendar

Software Lifecycle

Device Operating System

Software Calendar

The following fields in the Device (Hardware table) and Installed Software (Software table) tables are stored in the Dual mode:

Device Table

Installed Software Table

Calculated Lifecycle Stage Name

Calculated Support Lifecycle Stage Name

Domain

 

Aggregated Tables

In Power BI, aggregated tables are tables that store pre-calculated, summarized, or aggregated data, which can help improve performance when working with large datasets. Instead of querying detailed data every time a report is rendered, aggregated tables provide a faster way to retrieve and visualize summarized data. These tables typically contain pre-summarized data (like totals, averages, or counts), reducing the need for complex calculations during report rendering. For information on measures, see Working With Measures.

The following measures are stored in the aggregated Hardware and Software tables:

Measures stored in aggregated Hardware table

Measures stored in aggregated Software table

#Devices

#Installs

#Devices GA

#Installs EOL

#Devices Missing Model Information

#Installs GA

#Devices Obsolete

#Installs Missing Version Information

#Devices Unpublished Lifecycle

#Installs Obsolete

#Devices Virtual System

#InstallsOpen Source Support

#Hardware Manufacturers

#Installs Unpublished Lifecycle

#Hardware Models

#Software Manufacturers

#Hardware Products

#Software Products

#Hardware Models Obsolete

#Software Releases

#Devices End of Sale Over Time

#Software Releases EOL

#Devices Obsolete Over Time

#Software Releases Obsolete

#Hardware Models End of Sale Over Time

#Software Versions

#Hardware Models Obsolete Over Time

#Software Obsolete

#Hardware Products End of Sale Over Time

Software Version to Product Ratio

#Hardware Products Obsolete Over Time

#Installs EOL Over Time

Device kgCO2e - Scope 1

#Installs Obsolete Over Time

Device kgCO2e - Scope 2

#Software Products EOL Over Time

Device kgCO2e - Scope 3

#Software Products Obsolete Over Time

Device kgCO2e - Total

#Software Releases Obsolete Over Time

Electricity Consumed (kWh)

#Software Versions EOL Over Time

 

#Software Versions Obsolete Over Time