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.
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.???
AgileJohn If you read the begining of the thread we discuss that data is accessed via the Autotask provided Warehouse...
To restate:
#1 - Autotask data is accessible via their Warehouse. From my understanding this may be an additional fee. They grant you access to this SQL instance where you can access a layer of Views in the Database that is assigned to your Org. This access grants you the ability to use SSIS to automate the extraction of data into your own environment to manipulate/control and generally do as you will with it.
As to your "solution" comment, you are correct, this is a high level framework that outlines how the initial poster can access data in Autotask, as well as utilize a Tabular model for use with the On Premises Data Gateway (Called the Analysis Services Connector back in 2015). You don't have to use a tabular model, and you can choose to connect to the warehouse directly if that suites you. And since we're just talking about how to connect to a data source to extract information, I don't see how testing/relevance has anything to do with this.
Thank you for correcting me. I was not aware that AutoTask had a direct DB access option. I've contacted them and found this is $250/mo and limited to 3 IP addresses.
Thank you for sharing!