Measured Employee Count is Greater than Licensed Employees

[Kevin_Corr]

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?

Thanks

[Nedbank]

Hi Kevin 

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. 

Thank you 

[Kevin_Corr]

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. 

[lmuca]

Hello Kevin,

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.

Thank you

[Kevin_Corr]

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.

[lmuca]

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.

Thank you

[Kevin_Corr]

Hi Imuca,

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

Kevin

[Nedbank]

Hello Kevin 

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.

Thank you

[Kevin_Corr]

Thanks Nedbank,

It seems that the queries themselves are resulting in the high counts of unique personid's, not the Power BI templates.