cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

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
_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 Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)