Answered

Query an Audit Table via the Dataverse Endpoint SQL Connection

(0) Share

Report

Posted on by edondata

I have a table with auditing enabled. I have edited records and can see changes in the App (by clicking Related > Audit History on a given record)

I can also see the latest version of table using the Dataverse Endpoint SQL Connection (in Power BI and SSMS) but I can't see the audit history of that table

Is it possible to query the audit history of a table? and if so how?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

Hi @edondata ,

I was going to work on a reply but this explains very well so thought I would share: https://dynamics-chronicles.com/article/dynamics-365-audit-explanation-deep-dive

Please accept if answered your question or Like if helped in any way.

Thanks much!

Drew

Was this reply helpful? Yes No
edondata 7 on at

Like (0)

Report

Thanks @dpoggemann. It seems from the article that the audit history from many tables is collected in 1 table called dbo.AuditBase. So that should work fine. The problem is I can't see dbo.AuditBase though via SSMS or Power BI. Any idea what I need to change?

Was this reply helpful? Yes No
Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report

Hi @edondata,

Looked as well and not visible in tables to choose from for Online, only on-premises environments...

Please see the following for a work-around:
https://community.dynamics.com/crm/f/microsoft-dynamics-crm-forum/272166/get-data-from-audit-history

Hopefully this works for you. If so, please accept solution and if helps somewhat, please Like.

Thanks,
Drew

Was this reply helpful? Yes No
edondata 7 on at

Like (0)

Report

Thanks @dpoggemann

I've added this as an idea so please vote if you encounter the same problem
https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Query-the-audit-history-of-a-table-via-the-Dataverse-Endpoint/idi-p/900190

Was this reply helpful? Yes No