Search code examples
powerbidaxpowerbi-desktopmicrosoft-fabric

How to Switch Power BI Dataset Based on Logged-in User Role (Microsoft Entra Security Group)?

In Power BI, I have a report where I need to mask data based on the logged-in user's role (determined by Microsoft Entra Security Group).

It appears that Power BI does not have a built-in feature to handle this directly.To address this, I'm considering maintaining two separate datasets: one with masked data and the other with unmasked data.

Is there a method to dynamically change the dataset source for the report based on the logged-in user?

Thank you, Praveen

Solution

  • You don't need to change the source. You can use RLS to securely manage what is shown to different users.

    https://learn.microsoft.com/en-us/fabric/security/service-admin-row-level-security