AutoTask Ticket History

Clear. The table TicketHistory is a table function (see What are table functions and table function parameters?).

A view can be created to use it from Power BI, but note that this require one API call per ticket. For instance, with 100.000 tickets in the filtered selection of 500.000 tickets in total, retrieval will trigger 100.000 API calls.

An example of the creation of a custom view can be found in Using custom database views for SQL and BI tools.

It is recommended to test this query first in the UniversalSQL-editor.