web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested Answer

Creating a PowerBI report for user activity in Dynamics 365

(0) ShareShare
ReportReport
Posted on by 25

Hi,

We are trying to create a PowerBI report for user activity in Dynamics 365. We need to find out who has logged into D365, for how long, the records they have created/updated in the past x days etc. Any idea how do we get this?

 

Previously this was possible using Application Insights in D365, which has now been deprecated. The solution for this should have been available through CDS for Analytics but this hasn’t arrived for Public Preview yet.

 

Appreciate your response.

I have the same question (0)
  • Suggested answer
    Robert Bailey Profile Picture
    20 on at

    Hi Pradeep,

    OOTBm These actions are tracked currently through audit logs. You'll want to enable auditing :

    docs.microsoft.com/.../enable-use-comprehensive-auditing

    You cannot report on audit logs the standard way through dynamics 365 or through PowerBI without custom work to duplicate the data. Audit log reports can only be built and exist within the Office 365 Security and Compliance Center.

    Alternatively, you could track the activity yourself by programmatically accessing the audit logs:

    docs.microsoft.com/.../get-started-with-office-365-management-apis

    This would let you create a custom entity to store a replica of the data formatted the way you want, and report on it with PowerBI.  This is effort-intensive - you may be best served waiting for CDS for Analytics.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Subra Profile Picture

Subra 120

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 92 Super User 2026 Season 1

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 83 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans