11-29-2022 01:23 PM - edited 11-29-2022 01:25 PM
Working with a customer and we recently noticed that the Measured Employee count being shown on PowerBI reports is significantly greater than the number of licensed employees.
Has anyone else observed this, and are there any suggestions to correct this?
11-30-2022 04:59 AM
The count on looks okay on our side. You are measuring all employees or only Active employees on WPA? If you can maybe check on that.
11-30-2022 05:06 AM
Thanks. We’re measuring active employees. Total measured employees are ~3,900, but we’re seeing ~6,100 unique person ID’s in the analysis results.
12-01-2022 05:42 AM
It's confusing i know but the number of measured employees you are looking ate the power bi file it's not the same as the measured employees on WPA. Meaning that the measured employees on the pbi file it's the distinct count of PersonId of the csv file of the organizational data uploaded in WPA. Instead, the measured employees you see in WPA are actually the Viva Insights licensed employees.
12-01-2022 03:16 PM
Thanks. I may not have explained the situation well enough.
We have approximately 3,900 licensed employees and we are seeing 6,000+ unique person ID's in the output of our analysis with associated measures. So it appears that we are measuring activity for more employees than we have assigned licenses to, which doesn't seem correct.
12-02-2022 05:32 AM
A best practice that MS suggests is to always have the same Viva Insights licensed employees inside the .csv file of the organizational data. MAybe you should try and "clean up" the .csv file.
12-02-2022 11:06 AM
Thanks again for your input. The actual best practice is to include all employees in the org data file, even employees who are not licensed (i.e., measured). Please see https://learn.microsoft.com/en-us/viva/insights/advanced/admin/prepare-org-data#employees-to-include
12-02-2022 12:51 AM
This is interesting count almost doubled. Lest do it this ways, check the count of employees on your Teams (viva insight) under organizational trend it should be 3,900 if so then we know the issue its on Powerbi. However, if the count is 6,000 then the issue its not on the powerbi template it's the license but I might be wrong.
12-02-2022 11:24 AM
It seems that the queries themselves are resulting in the high counts of unique personid's, not the Power BI templates.