How to enforce Row-Level Security for Fabric Data Agent when connected directly to Lakehouse tables

Question

Hi Team,

I’m looking for help regarding Row‑Level Security (RLS) with Fabric Data Agent.

Scenario

• We have created a Fabric Data Agent
• The Data Agent is directly connected to Lakehouse tables
• The Data Agent is NOT built on a semantic mode

Requirement

We need row-level security so that users only see the data they’re authorized to see (similar to how RLS works in Power BI)
Example: When a Sales Head logs in through a custom portal and queries the Fabric Data Agent, they should be able to see only the rows assigned to them as the Sales Head. We also have a master table that stores the Sales Head email IDs and their assignments.

Questions

• Is RLS on Lakehouse tables expected to be enforced when accessed via Fabric Data Agent?
• Is there any supported way to implement RLS for a Data Agent built directly on Lakehouse tables (without using a semantic model)?

Answer 1

Hello @Ranjitha

Thanks for reaching out in Microsoft Q&A forum,

Fabric related query is currently not supported in the Q&A forums, the supported products are listed over here Supported products on MS Q&A (more to be added later on).

You can ask the experts in the dedicated MS Power platform community forum.

Can you please open as a new thread in MS Power platform community Find Answers | Microsoft Power Platform Community

I hope it helps! and do let me know if you have further queries