Power BI & DAX: How to Use Breadcrumbs to Fix the Fatal Flaw of the Filter Pane

in this video I talk about the fatal flaw of the Power BI's Filter pane and how we can fix it with breadcrumbs. What fatal flaw am I talking about? What the heck is a breadcrumb? Well, watch the video and you will find out. https://youtu.be/6HHbPzqhcn8 These are the measures that I have created to … Continue reading Power BI & DAX: How to Use Breadcrumbs to Fix the Fatal Flaw of the Filter Pane

Microsoft SQL Server 2012 With PowerView For Multidimensional Models is available in CTP

Microsoft demonstrated PowerView on top of the Multidimensional model in Analysis Services several weeks ago at SQL PASS and now the CTP version of the product is available here. There are two pieces of new functionality delivered with this CTP: Update for Analysis Services engine to allow DAX support for Multidimensional models Update for the … Continue reading Microsoft SQL Server 2012 With PowerView For Multidimensional Models is available in CTP

Dynamic security in a tabular model for analysis services

The second iteration of the tabular model for analysis services now allows us to implement very sophisticated security scenarios including row-level dynamic security.  In order to implement it, first we need the means of finding out the windows credentials of the user.  That can be accomplished using the DAX function USERNAME(). Second, we need to map … Continue reading Dynamic security in a tabular model for analysis services

Microsoft SQL Server 2012 Virtual Labs

Microsoft has posted 16 virtual labs online. The labs cover three major areas: Business Intelligence Mission Critical Operations Database Management Those of us who are trying to jump start Self Service BI in our organizations should checkout the following three: Creating a PowerPivot Model and Report in the Excel Client Defining DAX Calculations with Microsoft … Continue reading Microsoft SQL Server 2012 Virtual Labs

Parent Child in PowerPivot

EDIT: I recorded a detailed video on how to work with Parent Child hierarchies in Power BI: https://businessintelligist.com/?p=2603 Kasper de Jonge posted a great article about building PowerPivot hierarchies against dimension tables that implement parent/child relatioship... Basically, a new PATH() DAX function is used to build a string that contains a path from the leaf … Continue reading Parent Child in PowerPivot