CODEWITHSUNDEEP
dynamics-crmpowerbimicrosoft-dynamicsdynamics-365row-level-security
SKocheta
SKocheta

Reputation: 133

PowerBI RLS Not working with Dynamics 365 PowerBI Dashboard

I am doing a POC on RLS (Row Level Security).

  1. I have a very basic Report which lists all leads and Their Owners
  2. I have a Role Defined with formula as: [internalemailaddress] = USERPRINCIPALNAME() on SystemUsers Table.
  3. Testing this on Desktop works
  4. Publish and Add Users to the Role
  5. Use PowerBI Dashboard Option inside Dynamics 365 to show this dashboard inside Dynamics CRM
  6. Login via One of the Users which has this PowerBI Role
  7. All The Rows are shown and No Filtering Occurs.

Please suggest If I am doing something wrong.

Also please suggest if there is a way via which System Roles/Groups define in CRM/O365 can be reused in PowerBI (e.g. SalesPerson should be able to view only his data, Sales-Manager should be able to get data of all sales person under his territory etc.)

Upvotes: 1

Views: 886

Answers (1)

Arun Vinoth PrecogTechnologies
Arun Vinoth PrecogTechnologies

Reputation: 22836

Either you have to change the owner of the dataset to someone else or login/test with a different CRM user to see RLS in action.

Referring this thread in Power BI community:

RLS wouldn't work on the owner of the dataset. Because the owner can edit both the dataset and reports. RLS aims at controlling the data access rather than something like filtering. You can run "Test as role" to see the effect.

enter image description here

Upvotes: 1

Related Questions