Power BI for Grownups

The message from the Microsoft Business Applications Summit this week was very clear: Power BI is growing up. We have…

Implementing Row-Level Security in Power BI

The best method to implement row-level security in a published Power BI model or SSAS Tabular model consumed from the Power BI service will depend to some degree on your data structure and requirements.  The method I demonstrate here is one of the most flexible approaches and one that I commonly use in my projects.

SSAS Tabular Modeling Article Series on SQL Server Pro Magazine

I’ve just finished a series of four articles for SQL Server Pro Magazine, along with sample projects and hands-on exercises. The series will take you through SSAS Tabular model design from start to finish, using the Adventure Works sample data in SQL Server 2012 or 2014. Here are links to all four articles followed by an excerpt from each.

Part 1 – Getting Started with SSAS Tabular
Part 2 – Easy DAX – Getting Started with Data Analysis Expressions
Part 3 – Tabular Model Administration
Part 4 – Deep Dive DAX – Solving Complex Business Problems with Data Analysis Expressions

Download the sample projects here: Part 1, Part 2, Part 3, Part 4

Power View for Multidimensional Cubes Released

The Power View connectivity for Multidimensional Models has been released to the public as part of SQL Server 2012 Service…

Power View Now Works with Cubes!

This is a very significant day in the progression of the Microsoft Business Intelligence platform.  Earlier this year, Power View…

%d bloggers like this: