Wednesday, May 24, 2017
 
Updates from SSAS Team (SQL Server Analysis Services) @ Microsoft

Get Aggregated RSS

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

Thursday, May 18, 2017

The public CTP 2.1 of SQL Server 2017 is available here! This public preview includes the following enhancements for Analysis Services tabular models. Shared M expressions are shown in the SSDT Tabular Model Explorer, and can be maintained using the Query Editor. Data Management View (DMV) improvements. Opening an file with the .MSDAX extension in... Read more

Building an Azure Analysis Services Model on Top of Azure Blob Storage—Part 1

Monday, May 15, 2017

In a comment to a recent blog article, Bill Anton raised a question about the target scenarios for the modern Get Data experience in Tabular 1400 models, especially concerning file-based data sources. So, let’s look at a concrete example from my personal to-do list: Building a Tabular model on top of industry standard synthetic data... Read more

1400 Compatibility Level in Azure Analysis Services

Thursday, May 04, 2017

We are excited to announce the public preview of the 1400 compatibility level for tabular models in Azure Analysis Services! This brings a host of new connectivity and modeling features for comprehensive, enterprise-scale analytic solutions delivering actionable insights. The 1400 compatibility level will also be available in SQL Server 2017 Analysis Services, ensuring a symmetric... Read more

Join Alberto Cairo at the Microsoft Data Insights Summit to Explore the Different Dimensions of Data Visualization

Tuesday, May 02, 2017

Known for his award-winning global achievements in infographics and multimedia as a professor, author, journalist and designer, we are excited to welcome data visualization expert Alberto Cairo back to the Microsoft Data Insights Summit, taking place June 12-13, 2017 in Seattle. This year Alberto will provide a special guest keynote focused on the different dimensions... Read more

SSMS Improvements for Analysis Services in the April 2017 Release

Wednesday, April 26, 2017

The April 2017 Release of SSMS for Analysis Services is the first release with support for the modern Get Data experience. This release also features additional capabilities for the DAX parser, which come in handy when authoring or fine-tuning queries in the DAX Query Window. Azure Analysis Services now also supports Multi-Factor Authentication (MFA) based... Read more

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

Wednesday, April 19, 2017

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... Read more

Introducing a DAX Editor Tool Window for SSDT Tabular

Wednesday, April 19, 2017

The April 2017 release of SSDT Tabular for Visual Studio 2015 and 2017 comes with a DAX editor tool window that can be considered a complement to or replacement for the formula bar. You can find it on the View menu under Other Windows, and then select DAX Editor, as the following screenshot illustrates. You... Read more

New Get Data Capabilities in the GA Release of SSDT Tabular 17.0 (April 2017)

Wednesday, April 19, 2017

With the General Availability (GA) release of SSDT 17.0, the modern Get Data experience in Analysis Service Tabular projects comes with several exciting improvements, including DirectQuery support (see the blog article “Introducing DirectQuery Support for Tabular 1400”), additional data sources (particularly file-based), and support for data access options that control how the mashup engine handles... Read more

Introducing DirectQuery Support for Tabular 1400

Wednesday, April 19, 2017

With the production release of SSDT 17.0, Tabular projects now support DirectQuery mode at the 1400 compatibility level, so you can tap into large data sets that exceed the available memory on the server and meet data freshness requirements that would otherwise be difficult if not impossible to achieve in Import mode. As with Tabular 1200... Read more

Meet the Azure Analysis Services team at upcoming user group meetings

Tuesday, April 18, 2017

Come meet the Analysis Services team in person as they answer your questions on Analysis Services in Azure. Learn about the new service and features available now. The success of any modern data-driven organization requires that information is available at the fingertips of every business user, not just IT professionals and data scientists, to guide their... Read more

HOME   |   SQL ARTICLES   |   SCRIPTS   |   DISCUSSIONS   |   SQL TEAMS   |   JOBS   |   ABOUT US
Copyright [2014] by SQLCOMMUNITY.COM