Forum Discussion
Autotask Data Warehouse Integration
Casey_Harless AutoTask won't be able to assist you, as you will need to build a Tabular model and deploy it to an SSAS (SQL Server Analysis Services) instance in your domain. The AS Connector then points at that SSAS instance.
If you are trying to use the connector - you will need to leverage the additional technologies Visual Studio (SQL Server Data Tools) and have a SQL SSAS instance.
I have been unable to direct connect to AutoTask from Power BI Desktop, so I had to pull the data I wanted into my own database using SSIS (Sql Server Integration Services - also a Visual Studio thing). I did this also so that I can leverage other company information as well. Then I built a tabular model, and deployed to my SSAS instance. Then I connected the AS Connector to my SSAS instance.
That is alot of info, so feel free to ask questions.
TLDR; You can't just hook up the AS Connector to AutoTask. It's not a model, and not in your domain.
Casey_Harless If you are following the above, then next steps would be something like this:
1) Get data from AutoTask into your database - Your SSIS process can be a scheduled SQL Agent Job
2) Create your tabular model based on the data in your database / Deploy model to SSAS Tabular SQL Instance
3) Create SSIS process to update your model - Schedule refresh of model by using SQL Agent Job
4) Download the PBI Analysis Services connector on to the instance of your SSAS Tabular model (Can be anywhere in your domain, but if you do it on the SSAS Tabular instance you don't have additional hops across your network.)
5) Connect to model in desktop or service
6) Data in your reports is automatically refreshed whenever you update your model with the SQL Agent Job
The great thing about the AS Connector is that if you connect to the model in the desktop tool, when you push that file to the Service the connection stays "live", it doesn't treat the PBIX file like an on-prem source like all the other datasources. It inherits the connection to the model and continues to just send DAX queries back and forth.
You can schedule the update of the model as often as you want, and I don't see why you couldn't create 1 SQL Agent Job with 2 steps. The first to load the data from AT, and the second to update the tabular model.
AnonymousThis does not appear to be a "solution", rather a high level framework that has not been tested or verified by any other community member to date.
The first step #1 has no information on how to get the data from AutoTask (a remote SaaS service). That's the hard part that got completely skipped over. No data, then all the other theortical infomation on analyzung the data is not helpful.
How are you actually connecting to and pulling the AutoTask data into PowerBI? REST Query, support ticket to export data to tab files, etc.???