Power Query in SSAS Tabular Model

[Anonymous]

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

[v-jiascu-msft]

Hi Mohan,

Could you please mark the proper answers as solutions?

Best Regards,
Dale

[_donev]

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