Topic: SSAS
-
If you create server aliases for SQL Server connections, you should be aware of the changes introduced in SQL Server 2022. At SQLBI we use aliases to identify the server’s name in the connection of our sample files (Power BI… Read more
-
When working on the Mastering Tabular video course, we needed a sample database with more data than what we had at our disposal in existing sample databases. We also wanted to be able to control the content so that different… Read more
-
UPDATE 2021-06-29: also read Choosing Azure Analysis Services or Power BI Premium for large datasets – SQLBI containing updates about Power BI Premium Gen2. I often get questions about use cases for Azure Analysis Services. So I wanted to do… Read more
-
Great news! Just one year after releasing the second edition of The Definitive Guide to DAX, we just published a new website, a new book, and a new collection of videos: the second edition of DAX Patterns! DAX Patterns is… Read more
-
Another year has gone by and it has now been 10 years since DAX was first introduced in late 2009. As usual, it is time to review the past year and to take a look at the year ahead. Read more
-
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
-
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 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
-
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
-
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