Can you tell me the regularity of the updates of Autotask-data in Invantive cloud? Is this adjustable? Also what time(s) does the updates occur?
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.
- 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.
This question was automatically closed after at least 2 weeks of inactivity after a possible solution was provided. The last answer given has been marked as a solution.
Please ask a new question via a separate topic if the problem occurs again. Please include a link to this topic in the new question by pasting its URL into the text.