Topic: SSAS
Updating tabular models for Ordinal property in calculation groups
If you created a Tabular model using one of the preview versions (CTP, RC, …) of Analysis Services 2019, you don’t have the final structure for the Ordinal attribute that Microsoft defined in the final version of compatibility level 1500.… Read more
Choosing Azure Analysis Services for large datasets
I often get questions about use cases for Azure Analysis Services. So I wanted to do a quick recap of the points I commonly discuss in these conversations, and have them readily available for the next conversation… As a bonus,… Read more
VertiPaq Analyzer 2.0 Preview 1
In 2015 I released the first version of VertiPaq Analyzer, a tool to quickly analyze the structure and data distribution of a Tabular model that can be used with Analysis Services and Power BI. Read more
The Definitive Guide to DAX second edition now available worldwide
The second edition of The Definitive Guide to DAX is now available worldwide! This blog post explains why we felt the need to rewrite the book and describes what happens behind the scenes when producing a book. Read more
Calculation Groups in DAX – first impressions
Microsoft announced at SqlBits a very important feature for DAX: Calculation Groups. These are my first impression about the new feature and the impact it will have on Analysis Services and Power BI. Read more
Change culture/collation of an Analysis Services Tabular database
When you create a Tabular model for Analysis Services, the Culture and Collation properties are set automatically and cannot be changed by the SSDT user interface in Visual Studio. The biggest issue is the workspace database, because these properties cannot… Read more
What has happened in the DAX world in 2017
We are approaching the end of 2017, so it is a good time to review what happened in the DAX world this year, what we’ve been up to at SQLBI and what is going to happen in 2018. New DAX… Read more
Sessions and preconference at Microsoft Ignite and PASS Summit
In the second half of 2017 I will deliver sessions and preconference days in two big events. I’d like to recap my sessions here, let me know if you have any questions about them. Microsoft Ignite 2017 – September 25-29,… Read more
New function and the importance of variables in #dax
I recently wrote a few articles about a new function in DAX and the use of variables. For those of you using Power BI or Azure Analysis Services, you always have access to the latest version of the language. Well, in reality I see that new features appears Read more
Learn DAX, data modeling, and data visualization after MS Data Insight Summit #dax #powerbi #dataviz
I spent three days in Seattle at Microsoft Data Insight Summit , delivering a preconference day about data modeling for business users, and two workshops about DAX. All of these were sold-out, so even if you attended the conference, you might be interested Read more