cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MohanV Established Member
Established Member

Power Query in SSAS Tabular Model

Currently we are using SSAS as our data source for reports creation.

 

Current version:- 

 

Microsoft Visual Studio Community 2017  Version 15.8.4

SQL Server Analysis Services 14.0.1016.285
Microsoft SQL Server Analysis Services Designer  Version 14.0.1016.285

SQL Server Data Tools 15.1.61808.07020

 

SQL Server:- 

 

Microsoft SQL Server Management Studio 14.0.17119.0
Microsoft Analysis Services Client Tools 14.0.608.142
Microsoft Data Access Components (MDAC) 6.3.9600.17415
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 9.11.9600.18861

As shown in the below link that the new version have the power query as data source in SSAS, so we are planning to upgrade to the new versions.

 

https://sqlserverbi.blog/2017/12/04/power-query-skills-apply-to-excel-power-bi-and-ssas-tabular/

 

https://www.youtube.com/watch?v=cJQpulLW-P0

 

Can anyone please suggest that what are the compatible versions needs to be installed so that we can have power query in SSAS.

 

Any help and suggestions will be lot more helpful.

 

Thanks,

Mohan V

 

 

 

 

2 REPLIES 2
Highlighted
_donev Frequent Visitor
Frequent Visitor

Re: Power Query in SSAS Tabular Model

Assuming you are asking for the modern Get Data experience in Visual Studio, you already have the correct versions. But to use it, you need your model to be in Compatibility 1400.

For reference - https://docs.microsoft.com/en-us/sql/analysis-services/what-s-new-in-sql-server-analysis-services-20...
Microsoft v-jiascu-msft
Microsoft

Re: Power Query in SSAS Tabular Model

Hi Mohan,

 

Could you please mark the proper answers as solutions?

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,630)