Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / How to get user last l...
Microsoft Dynamics 365 | Integration, Dataverse...
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
 
 
 
 
 
 
  • 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

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans