Forum Discussion
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
- 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-2017?view=sql-server-2017#modern-get-data-experience Hi Mohan,
Could you please mark the proper answers as solutions?
Best Regards,
Dale
