The data model of the Autotask API with all Autotask tables for use with Invantive SQL, Power BI, Excel and others is available online on https://documentation.invantive.com/2017R2/autotask-data-model/webhelp/index.html.
The documentation presents a table per API method and endpoint. Using familiar SQL statements the ticket status or notes can be analyzed and reported upon through a simple SQL query.
The use of Autotask from with Invantive requires registration of an Autotask API user, secret (password) and integration code as described in Determine Autotask API user and password for Power BI connector and SQL.
The registration steps for the Power BI Autotask connector can be found on Connect Power BI to Autotask.
The steps to load a database with Autotask with Azure Data Factory are available on Autotask Azure Data Factory connector, 180 days free.
The most popular Autotask tables can be found on: