THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Damian Widera

What’s new in SQL Server 2017 CTP 2.0 for Analysis Services

Today is a great day. I have been able to take part in the #MSDataAmp conference. While listening to Scott Guthrie I found that SQL Server 2017 CTP 2.0 is available for download

I like to way Microsoft changes the Analysis Services engine over the time. I just had opportunity to take a look what the engine offered in 2012 and to see how it has been changed since then is very impressive

Here is what is new / changed / enhanced in the SQL Server 2017 CTP 2.0 in the SSAS engine (text copied from the Analysis Services Team Blog)

The public CTP 2.0 of SQL Server 2017 on Windows is available here! This public preview includes the following enhancements for Analysis Services tabular.

  • Object-level security to secure model metadata in addition to data.
  • Transaction-performance improvements for a more responsive developer experience.
  • Dynamic Management View improvements for 1200 and 1400 models enabling dependency analysis and reporting.
  • Improvements to the authoring experience of detail rows expressions.
  • Hierarchy and column reuse to be surfaced in more helpful locations in the Power BI field list.
  • Date relationships to easily create relationships to date dimensions based on date columns.
  • Default installation option for Analysis Services is tabular, not multidimensional.

Other enhancements not covered by this post include the following.

  • New Power Query data sources. See this post for more info.
  • DAX Editor for SSDT. See this post for more info.
  • Existing Direct Query data sources support for M expressions. See this post for more info.
  • SSMS improvements, such as viewing, editing, and scripting support for structured data sources.

The complete blog post is here:




Published Wednesday, April 19, 2017 9:04 PM by Damian

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



kailey said:,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

August 5, 2017 1:45 AM

chenyingying said:


May 6, 2018 10:44 PM

linying123 said:


May 10, 2018 8:07 PM

shenyuhang said:


June 1, 2018 7:00 PM

linying123 said:



July 16, 2018 8:28 PM

dongdong8 said:



July 23, 2018 11:26 PM

yaoxuemei said:


August 15, 2018 2:01 AM

karin said:

August 15, 2018 3:51 AM

chenjinyan said:


August 22, 2018 11:03 PM

shenyuhang said:


August 23, 2018 10:13 PM

chenlixiang said:



September 18, 2018 9:54 PM

chenjinyan said:


October 9, 2018 6:53 PM

chenqiuying said:


October 10, 2018 5:53 PM

Hasilbertapa said:

I ‘d mention that we site visitors are extremely lucky to live in a fantastic community with very many awesome people with interesting principles. I feel very happy to have seen your weblog and look forward to some more cool moments reading here. Thanks once again for all the details.<

October 23, 2018 6:53 PM

Leave a Comment

Privacy Statement