Access / Export CRM 365 Audit Log Data

Question

Trying to get Microsoft CRM 365 Audit Log Data into Power BI for reporting.

Tried OData Feed Connector to CRM 365, It does connect, but can't see the Audit Log Tables.

Is there a way to extract Audit Log Records from CRM to excel or csv?

score 0 · Answer 1 · answered Feb 27 '19 at 13:34

0

The Dynamics 365 connector & oData connector seems to be not working for Audit entity set from this community discussion and this PowerBI one

For understanding how/what format the Audit data is stored - I have written in detail on this SO thread.

answered Feb 27 '19 at 13:34

score 0 · Answer 2 · answered Feb 28 '19 at 08:13

0

I used these instructions successfully to get the users last login information to a Power BI report:

answered Feb 28 '19 at 08:13

HML

While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes – Stefan Becker Feb 28 '19 at 08:16

2 Answers2