Access CRM Audit History Data in Desktop

[kkushniruk]

How can I access the audit history tables from CRM Online in Power BI desktop? Looking to pull this data in for the Opportunity table.

[v-yuta-msft · Accepted solution]

Hi kkushniruk,

So your requirement is to achieve audit data through http request? Maybe this link can help you: https://mahadeomatre.blogspot.com/2015/02/ms-crm-audit-database-table-details.html.

Regards,

Jimmy Tao

[kkushniruk]

Hi Jimmy - I'm trying to access the underlying audit data in Dynamics online and pull it into Power BI using the Dynamics Online connector. I could also use the OData connector. I;m unsure what the table schema name is to access this information.