Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I've recently been at a couple of Power BI Conferences where one of the topics which generated some confusion to Citizen Power BI Developers was Dynamic Row Level Security and the DAX related to it. In this article, I will explain it in a very easy and understandable way, and go through every used function step by step.
As it's not possible to view the model and formulas online, neither publish to web with active RLS, I suggest the following:
- Download the PBIX. This will enable you to see the underlying model, formulas, and view as another person.
- Make sure to read the blog post here. It will show you the DAX formulas step by step.
eyJrIjoiYzlkODZlNDQtYWFjMy00MWY2LTg0MWUtZDk4Y2IzZjk1MzljIiwidCI6IjMzY2EzNmVmLTU5NWItNDU3Ni1iMjVkLWRiNDk4ZmM1OWVhMiIsImMiOjl9