Microsoft Usage Analytics Data Refresh

Question

Hello,

I was generating a Microsoft usage report and successfully built the dashboard using Power BI. However, I’ve noticed that user departments are not classified correctly in the report.

I have already updated the user department information in our Microsoft 365 tenant, and when I export a user report directly, the correct departments appear. Despite setting scheduled refresh times (which complete successfully), the updated department data is still not reflected in the Power BI dashboard.

If you have any ideas or suggestions on how to resolve this issue, they would be greatly appreciated.

Regards Simon

Answer 1

Hello again.

I'm here just to do a quick follow up and ask you if the processes I shared were helpful.

I'll be here if you need further guidance.

Best Regards,

Daniel C.

Microsoft Community Support

Answer 2

Hello.

Welcome to the Microsoft Community.

From what you've described, it seems that the user department data updated in Microsoft 365 isn't flowing through to your Power BI usage analytics dashboard, even after a successful refresh.

While the Power BI Dashboard pulls data from Microsoft 365, it's important to note that the Microsoft 365 Usage Analytics content pack doesn't immediately reflect changes made in Azure AD (such as department field updates). These updates are typically captured by the Microsoft 365 usage reports, but they may take time to be indexed and made available in the dataset.

So, I'd recommend a few steps and considerations you might want to try:

• Confirm that Department Attributes are Synced to Azure AD. Ensure that updated department values in your Microsoft 365 tenant are being correctly synced to Azure Active Directory, as that's where Power BI pulls metadata for user attributes.
• Check Microsoft 365 Usage Analytics Schema. The dataset used in Microsoft 365 usage analytics may not include the full set of custom or updated user properties. (About Microsoft 365 usage analytics - Microsoft 365 admin | Microsoft Learn).
• Consider using the Graph API for Custom Data Pulls. If you need more granular or real-time data, using the most up-to-date user attributes like department, using Microsoft Graph API with Power BI might be a more flexible solution. This allows you to build a custom dataset that reflects exactly what you see in your Microsoft 365 tenant.

Let me know how it goes.

Best Regards,

Daniel C.

Microsoft Community Support