PowerBI Report for Email Statistics - Not Updating User Departments.

[bensercombe]

Good afternoon,

First of all, I am a novice PowerBI user and have been tasked to create a PowerBI report for user/department email statistics.

I've used the pre-built Microsoft 365 Usage App/report and modifying it to show the statistics of user emails, which seesm to be working fine.
However, it is not updating the users' departments, even though they have been updated on-premises AD > Azure Entra ID user properties updated and are showing the correct departments.

Any ideas as to why it isn't updating?

Thanks in advance!

[bensercombe]

Thanks for getting back to me.

I have refreshed the data and even set a scheduled refresh prior to my original post, but the data for the departments still doesn't appear to be updated.
The actual stats do appear to be updating.

Below is an example showing the data refresh:

[GilbertQ]

Hi @bensercombe 

What you need to do is to set up a scheduled refresh to refresh the data.

Here are more details: Configure scheduled refresh - Power BI | Microsoft Learn