How to get Power BI Row Level Security (RLS) Role users, details and export to CSV
In a previous tweet on twitter, I had elaborated on how I had extracted the RLS Roles with the details and then exported it into a CSV file which then allowed the organization to keep an audit of the RLS for the dataset. In the steps below I will show you how I did this. In my previous blog post…
Row Level Security – Part 9 | Migrating AAS to PPU
In this blog post I am going to cover how to implement Row Level Security (RSL) when using AAS and how this can be done on PPU. In my example below I am going to show creating to simple RLS roles which will limit data for the users who belong to 2 roles. Role 1 – USA This role is…
Configure OLS in Power BI using Tabular Editor to limit access to non-financial measures
What Object Level Security (OLS) allows me to do, is to define which tables or columns users can or cannot see. My example which I am going to detail below will show you how I will restrict a user from viewing sales data. The same user will be able to see Quantity amounts. This becomes really powerful because not all…
Did you know you can now selectively show report pages for specific users in Power BI?
With the update to the latest version in Power BI Desktop there is now the capability to control which users will see which pages in a report. This is achieved using a combination of Row Level Security (RLS) and conditional formatting. This makes it a secure way of controlling access for specific users. I will demonstrate how this works below….
Unleash row level security patterns in Microsoft Power BI – Business Applications Summit
I was fortunate enough to be able to attend the Business Applications Summit in Seattle this year. I had an incredible time, met a lot of people that I have looked up to, read their blogs and watched their video’s. As well as made some new friends. One of the things that stood out for me was how easy it…
Dynamic Row Level Security is easy with Active Directory Security Groups
I am really excited to show you in this blog post how to use Active Directory (AD) Security groups to make Dynamic Row Level Security (DRLS) easy and simple. In the past when using DRLS there had to be a list maintained of all the users, along with what Row Level Security they required. As can be seen with the…
BI-NSIGHT – Power BI (Service Update 2) – SQL Server (Dev Essentials) – SQL Server 2016 (RC2)
As of the time of writing this, there was not a lot going on this week. And it is quite understandable with all that happened in the Power BI area at the Microsoft Data Insights Summit. So here are this week’s updates. Power BI – Service Update 2 I have to say that the Service Update 2, has a whole…