I have suffered a great deal of pain while implementing and more so while validating Row Level Security in Power BI. Let me try to capture all the steps for implementing and validating RLS in Power BI.
I have created a Sample Sales Dashboard in Power BI.
The main dataset is from table SAMPLE_DATA. The objective is to implement RLS by geography. The lowest grain of the geography is city.
Assuming there are 3 types of user,
- City - Has access to a single city only
- State - Has access to state level (multiple cities)
- Corp - Has access to all cities
I have created table SAMPLE_DATA_CITY from SAMPLE_DATA to have
