Forum Discussion

Silver Contributor

Jan 12, 2023

Solved

Blank fields in PBI reports as number of employees and UPNs do not match?

Dear community, When I create standard, out-of-the-box PBI reports (Meeting Effectiveness, Employee Wellbeing, etc.), there are additional fields/values added to my attributes which appear as blank...

VI_Migration
Jan 15, 2023
Hi VI_Migration,
I also found this when performing custom analysis, and while not much different from what you're doing already, thought I'd share my solution:
1. Clean the HR data file: I did a thorough clean of the file, ensuring no duplication, empty values etc. before each upload.
2. When creating the query, ensured that the "Active only" option was ticked
3. Once the data was pulled into Power BI, removed all blanks from the Organization field in Power Query editor.
Not sure if that will help - but I found that point 3 made working with the data much quicker and cleaner.
Keep well!

VI_Migration

Silver Contributor

Jan 15, 2023

Hi VI_Migration,

I also found this when performing custom analysis, and while not much different from what you're doing already, thought I'd share my solution:

1. Clean the HR data file: I did a thorough clean of the file, ensuring no duplication, empty values etc. before each upload.

2. When creating the query, ensured that the "Active only" option was ticked

3. Once the data was pulled into Power BI, removed all blanks from the Organization field in Power Query editor.

Not sure if that will help - but I found that point 3 made working with the data much quicker and cleaner.

Keep well!