Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Casey_Harless
New Member

Autotask Data Warehouse Integration

‎10-06-2015 11:18 AM

As a person with little database experience, and first time user to PowerBI, I would like some lay-person-level advice on how to import data from Autotask. Autotask has a Data Warehouse that, according to them, "Any reporting tool that can access Microsoft SQL Server views can use the Autotask Report Data Warehouse." (source) It seems the AS Connector is running into an issue and doesn't seem to be much of an option (I am in contact with Autotask about this). I cannot imagine this is an obscure request, perhaps there is already a work around?

 

Message 1 of 23
18,152 Views
0
1 ACCEPTED SOLUTION
Seth_C_Bauer
Community Champion
Community Champion

‎10-06-2015 12:54 PM

@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.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

Message 2 of 23
22,076 Views
0
22 REPLIES 22
sjoerd_slabbers
New Member
In response to Seth_C_Bauer

‎07-07-2016 05:28 AM

Hi Casey, did you managed to get this working?

Message 5 of 23
12,135 Views
0
Seth_C_Bauer
Community Champion
Community Champion
In response to sjoerd_slabbers

‎07-07-2016 06:04 AM

@sjoerd_slabbers Do you have a specific question surrounding accessing the data in AT? Or are you just interested in whether or not setting up the process worked?


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG
Message 6 of 23
10,799 Views
0

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

View All