


Making Analysis Services even more powerful
Now you can easily build your Analysis Service models based on data coming from an even wider range of external data sources. And more data leads to more meaningful insights.
Making Analysis Services even more powerful
Now you can easily build your Analysis Service models based on data coming from an even wider range of external data sources. And more data leads to more meaningful insights.

Connect and conquer
Together with our ISV partners, we’ve created a set of data connectors based on what Power BI professional developers want most. And we’re building more every day.
Combining data the easy way
With Power Query you can define multiple tables in your data model with relationships across them, or use the Merge/Append capabilities to combine them into a single table. Just like that.
Zero code
Transform and reshape your data with the Power Query Editor that gives you more than 300 transformations to choose from—easily get your data in the right shape, no matter where it comes from.
To get a deeper understanding, dive here

It’s easy to become a Power Query expert—Just follow these links!
SQL Server Analysis Services and Azure Analysis Service
Getting started with Power Query in SQL Server Analysis Services or Azure Analysis Services
Get started
Download SQL Server Developer Tools for Visual Studio and get started building your Analysis Services models today. See how much more you can do with your data. Fast.