Microsoft Dynamics 365 | Integration, Dataverse...

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

(1) Share

Report

Posted on by Community member

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

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community member 2 on at

Like (0)

Report

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?

I followed this url https://softchief.com/2022/07/26/use-fetchxml-in-web-api-using-power-automate-with-http-action-for-dataverse-and-dynamics-365/

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.

Was this reply helpful? Yes No
Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report

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:

https://<crm url>/api/data/v9.2/audits

More information:

audit EntityType web API reference:

audit EntityType (Microsoft.Dynamics.CRM) | Microsoft Learn

Was this reply helpful? Yes No