The data is retrieved in real-time from Autotask and directly forwarded in a streaming fashion to Power BI. This reduces information security risks and makes the moment of Power BI download time the same time as the replication moment, effectively solving inter-process synchronization issues.
However, for performance reasons, a cache is maintained.
See also:
- Differentiate OData4 for Power BI Cache Behavior to learn how to configure cache lifetime.
- Avoid timeout error on Power BI OData download to learn how to configure Power BI to avoid time-outs errors due to the real-time nature.
- Invantive Cloud Structure to learn the general structure of the dataflow from Autotask through the Invantive Cloud to Power BI.
For replication of Autotask into a custom database you can also use an ETL-tool such as Azure Data Factory or use a replication module as described for instance in Elementary Data Replication Module between Exact Online and Azure SQL Server.
Please leave a reply in case you have a more detailed question or the answer is not sufficient clear. In case this answer solves your question, please check “Solution” below this answer.