Archive - Blog Posts on SSAS

Calculation Groups are Coming to DAX - I woke up Saturday morning to a lot of chatter and blog articles about an announcement that Microsoft made at SQL Bits.  Microsoft is adding “Calculation Groups” to the DAX language. There are a number of blogs already that talk about the announcement, including Chris Webb and The Italians, but I wanted to give my […] Read More
Extract Table Size from Power BI Desktop Using DAX Studio - I was explaining to one of my blog readers recently how to extract table size from Power BI Desktop using DAX Studio and thought it would be useful for others.  I have covered the basics of DAX Studio in the past so I wont cover this detail again here. The latest version of DAX Studio can be […] Read More
Relationships in Power BI and Power Pivot - Level: Beginners Power Pivot is a database that has been designed from the ground up to be optimised for reporting and analysis in Power BI, Power Pivot for Excel and SSAS Tabular.  The technology is essentially the same across all of these products so I will generically refer to Power Pivot in this article. Power […] Read More
Power BI On Premise – Not in the Cloud! - Microsoft has recently released a technical preview of Power BI that can be installed on premise inside a company firewall and the Power BI reports can be securely published over the Intranet (not Internet) via SSRS.  Today I am sharing my experiences setting up the technical preview for the first time.  I installed the software […] Read More