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.

PASS Business Analytics Conference Hands-on Micro Workshop

I’m jumping on a plane bound for San Jose, California today headed to the PASS Business Analytics Conference (BAC).  If you plan to attend my hands-on workshop, Tuesday at 2:00, the following information will help you prepare:

Bring your laptop
running Windows 7, 8 or 10.  Power BI will work, at minimum, on Windows 7 32 bit with 4 GB of RAM.  A 64-bit OS with more RAM is better but not required.  When you install Power BI Desktop on Windows 7, you may be instructed to install the .NET Framework 4.5.  Please do this ahead of time.

Install Power BI Desktop
Just go to and install it from the Products menu.  You don’t need an account to install Power BI Desktop.

Charge your laptop battery
We will be meeting in a standard session room in the afternoon without additional power.  Plan to spend the two hours running on battery power (and don’t use up your battery charge earlier in the day).  I don’t have control over the schedule or meeting room facilities so please plan ahead.  We also won’t have control of the wireless Internet connectivity which I hope to use to provide files and exercise instructions.  Just in case of connection issues, I will provide files on USB drives.

If you do not yet have a subscription setup at, that’s OK.  In this shorter version of the workshop, we will spend most of the time working offline.  If you do have a subscription, you can publish and work with the online features but this is not a requirement.

Really looking forward to seeing you there!