RLS in Power BI report with Direct Query to Azure SQL Database

[Rohitb]

I have the below table in Az SQL database :

Employee table

EmployeeId, FullName, EmailId,""""""""""

And I am accessing the above table from the Az SQL database in the report via direct query.

The users have full read access on the database on the entire table.

And I have created a role in the Power Bi report as below :

But still the user is able to see all the data.

Is it because he/she has full read access on the database?

Then how should RLS be implemented on the report with direct query to the Az SQL Database

[v-ssriganesh]

Hello @Rohitb,

Hope everything’s going great with you. Just checking in has the issue been resolved or are you still running into problems? Sharing an update can really help others facing the same thing.

Thank you.

[v-ssriganesh]

Hello @Rohitb,

We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.

Thank you.

[v-ssriganesh]

Hi @Rohitb,

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to @ibarrau for sharing valuable insights.

Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.

Thank you for being part of the Microsoft Fabric Community.

[ibarrau]

Hi. It looks good, let me add something. Make sure the user is just viewer at the workspace, any other role will let them see everything even if they have RLS assigned. Otherwise, you can just share the report/app and don't even add user at the workspace. Make sure that there is no sharing or building permission enabled when sharing.

I hope that helps,