-
This page contains descriptions and links to necessary tools and resources for DAX and Tabular developers. Read more
-
This article describes the differences in the levels available in Azure Analysis Services (Azure AS), comparing them with the features in SQL Server Analysis Services (SSAS) on-premises. Read more
-
I will be a speaker at PASS Summit 2010 (November 8-11, 2010 – Seattle, WA) and sessions have been published yesterday. I am currently writing the last chapter of the book about PowerPivot that will be available in September, so… Read more
-
Every measure imported from a SSAS cube is imported as a Text column instead of as a Numeric column. This is very annoying because users are used to use SSAS data with rich metadata, and a measure is usually numeric.… Read more
-
I and Alberto Ferrari delivered many SSAS Tabular Workshops in the last 18 months and based on the feedback we received, we are moving toward a renewed edition. Instead of a 2-day seminar, we will run a 3-day course including… Read more
-
If you run SSAS Tabular or Power BI, please help me in gathering some performance data for a study I’m doing about Formula Engine performance following these steps: 1) Copy the PowerShell code below in a script Benchmark.ps1, modifying serverName,… Read more
-
Does PowerPivot handle Parent/Child hierarchies? The common answer is “no”, since it does not handle them natively. During last PowerPivot course in London, I have been asked the same question once more and had an interesting discussion about this severe… Read more
-
This article describes the pros and cons of using SQL Server Analysis Services Tabular as the analytical engine in a service or application, based on the experience of companies who have adopted it. Read more
-
Don’t miss the best course on Tabular modeling in Microsoft SQL Server Analysis Services 2012 by SQLBI experts. 0:12 – Who is the ideal attendee for the SSAS Tabular Workshop? 1:26 – What previous knowledge is required to attend the… Watch now
-
This article describes the semantic difference between ALLEXCEPT and the joint use of ALL and VALUES, showing practical examples of the different results in Power BI and SSAS 2016. Read more