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.
Hi Casey
I use Autotask datwarehouse and have managed to use the SQl connector to import directly to my power Bi giving me the custom dashboards I need. If this is still somehting you are having issue with then I am more than happy to do my best to help.
"Autotask datwarehouse and have managed to use the SQl connector to import directly..."
Can you please explain the process (preferably in steps) and tools/technologies required. A simple sample app can help a lot if you can upload.
Many Thanks
HHassan The Autotask warehouse is based in SQL Server. If you want to, you could directly connect from Power BI to that SQL Server, provided you are paying for the access to the database.
Get Data -> SQL Server -> Enter the Server -> Select your provisioned Database -> Enter SQL Credentials and you can access your views.
Anonymous Thanks for the details.
I just wanted to confirm: Following the Get Data, where do you get the option of SQL Server?
Did you mean: Get Data -> Databases -> SQL Server Analysis Services?
Pierre1007 My guess is that you are in the Power BI Service. You need to use the Power BI Desktop. Selecting "SQL Server" from the dropdown, should look like this:
