Skip to main content

Notifications

Announcements

Share Your Journey with Power Pages and Help Shape Its Future!
News and Announcements icon
Dynamics 365 Community / Forums / Dynamics 365 general forum / How to get user last l...
Dynamics 365 general forum
Suggested answer

How to get user last login date from D365 using Power BI

(1) ShareShare
ReportReport
Posted on by Community member 2
Hi , I would like to find out user last login to D365 portal for monthly review so would like to extract user with last login date. I saw this article How to – Get User’s last logon time in Dynamics 365 – Nishant Rana's Weblog , this is useful but I would like to extract the information. Could someone share what is table used for this report so that we can do powerbi report similar to the audit summary view table report? I saw there is system users table. I tried using the fetchxml method in the article but there is error when i tried to call the API
 
 
 
 
 
 
Categories:
Other Functionality
  • Suggested answer
    Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    How to get user last login date from D365 using Power BI
    Hi Partner，
    Why use account entity names in your process?
    The link just takes account as a demonstration, you should use audit entity name.
    Tring to use this:
    More information:
    audit EntityType web API reference:
  • Community member Profile Picture
    Community member 2 on at
    How to get user last login date from D365 using Power BI
    Hi Leah,
     
    THanks for your reply. I tried to use it in power automate . can you enlighten me what should be the correct url and parameters? 
     
     
    what should be the uri? https://<crm url>/api/data/v9.2/ or https://<crm url>/api/data/v9.2/accounts ?
     
     
    i keep having this error HTTP Error 400. The request is badly formed.
  • Suggested answer
    Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    How to get user last login date from D365 using Power BI
    Hi Partner,
    Not working?
    I can run the fetchxml successfully:
    --This involves two main entities: audit and systemuser.
    I hope you can verify my answer if it helps you! If you have any questions, please feel free to contact me.
    Regards,
    Leah

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

News and Announcements

Share Your Journey with Power Pages and Help Shape Its Future!

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans