Flexera One Blog — HArumugasamy_E (Flexera Software)
IT Visibility - TI Platform:
Important Notice: Report Updates Due to Data Model Maintenance
Maintenance Dated: 02/03/2025
With the recent Reporting enhancement on Many to Many Join performance issues, few adjustments were made to the Data model.
- No OOTB Report is impacted with this change
- If a custom report is created with fields from the below tables without a measure in their visuals, such visuals would start failing. #Devices for Hardware and #Installs from Software can be used in the visuals or tables to resolve the issue.
Hardware
Device Processor
Device Business Service
Device Network Adapter
Device Context
Software
Device Business Service
Software Context
Device Context
Software File Evidence
Software Installer Evidence
Note:
For any aggregations, It is recommended to use the Measures that already exist in the model as they are tweaked to be performant instead of aggregating data manually at a column level. If there are no aggregated measure in the visual, it is best to use #Devices for Hardware and #Installs from Software for the visual to be performant.
Documents on Measures and Report types could be found here:
So, is it no longer possible to join Software Device to Softwrae File Evidence or Software Installer Evidence? It can be done via the API but it doesn't seem like it's possible in PowerBI any longer after this change. Being able to do this helps us drill down on specific devices to see what file/installer evidence was discovered.
In the current setup there's no way to see what evidence is paired to the device.
Hello John, We could. The only step we need to do is add #Devices for Hardware and #Installs from Softwares as it acts as the bridge measure for these.