{"id":7301,"date":"2017-01-24T19:01:19","date_gmt":"2017-01-24T19:01:19","guid":{"rendered":"https:\/\/next-step.es\/?p=7301"},"modified":"2017-01-24T19:01:19","modified_gmt":"2017-01-24T19:01:19","slug":"upcoming-developments-in-tabular-analysis-services","status":"publish","type":"post","link":"https:\/\/next-step.es\/en\/proximas-novedades-en-analysis-services-tabular\/","title":{"rendered":"Upcoming News in Analysis Services Tabular"},"content":{"rendered":"<p>The preview of CTP 1.1 of SQL Server vNext, the latest version of SQLServer, contains important new features and enhancements for Analysis Services Tabular:<\/p>\n<p>Connecting to new data sources as currently offered by Power BI: multiple file types, databases, Azure sources and other online services, Big Data systems, Facebook, etc.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/next-step.es\/wp-content\/uploads\/2016\/11\/NuevasFuentes.png\" alt=\"NewOrigins\" \/><\/p>\n<p>Possibility of transforming data directly into the tabular model: dividing columns, hiding columns, changing data types, etc. using a query editor in the style of Power Query and PowerBI.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/next-step.es\/wp-content\/uploads\/2016\/11\/QueryEditor.png\" alt=\"QueryEditor\" \/><\/p>\n<p>Custom drill down in Microsoft Excel: allows you to customize the detail of a measure's data in an aggregate report. For instance, when end users see the total sales per region and per month, they can see the detail of the associated order.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignleft\" src=\"https:\/\/next-step.es\/wp-content\/uploads\/2016\/11\/DrillDownPersonalizables.png\" alt=\"DrillDownPers\" width=\"405\" height=\"317\" \/><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/next-step.es\/wp-content\/uploads\/2016\/11\/DrillDownPersonalizables2.png\" alt=\"DrillDownPers2\" width=\"525\" height=\"323\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>These enhancements, along with DAX's improvements and security enhancements, will make tabular models the most recommended in most scenarios. You can see further details in this <a href=\"https:\/\/blogs.msdn.microsoft.com\/analysisservices\/2016\/12\/16\/introducing-a-modern-get-data-experience-for-sql-server-vnext-on-windows-ctp-1-1-for-analysis-services\/\">Microsoft blog <\/a>entry.<\/p>","protected":false},"excerpt":{"rendered":"<p>The preview of CTP 1.1 of SQL Server vNext, the latest version of SQLServer, contains important new features and enhancements for Analysis Services Tabular: Connecting to new data sources as currently offered by Power BI: multiple file types, databases, Azure sources and other online services, Big Data systems, Facebook, etc. Possibility of transforming data directly [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":6781,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[3],"tags":[34],"class_list":["post-7301","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-analysis-services-en","tag-analysis-services-en"],"_links":{"self":[{"href":"https:\/\/next-step.es\/en\/wp-json\/wp\/v2\/posts\/7301","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/next-step.es\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/next-step.es\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/next-step.es\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/next-step.es\/en\/wp-json\/wp\/v2\/comments?post=7301"}],"version-history":[{"count":0,"href":"https:\/\/next-step.es\/en\/wp-json\/wp\/v2\/posts\/7301\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/next-step.es\/en\/wp-json\/wp\/v2\/media\/6781"}],"wp:attachment":[{"href":"https:\/\/next-step.es\/en\/wp-json\/wp\/v2\/media?parent=7301"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/next-step.es\/en\/wp-json\/wp\/v2\/categories?post=7301"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/next-step.es\/en\/wp-json\/wp\/v2\/tags?post=7301"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}