I have created a Copilot Studio Agent and added a text file as the knowledge source. The text file includes organizational department data (HR, Finance, Design and Development, and IT), with Year and Quarter-wise KPIs and Projects. I need to implement row-level security for AI responses so that, for example, the HR department cannot see Finance department KPIs and Projects, and the same restriction applies across other departments. Kindly guide me on how I can achieve row-level security for departments in Copilot Studio.
You can enforce row‑level security (RLS) in Copilot Studi, but not directly within a flat text file used as a knowledge source. Instead, you’ll need to leverage Microsoft's broader platform tooling to control which departmental data each user can access.
Option 1: Use Microsoft Dataverse + RLS (Recommended)
It's a bit complicated to set up. Advanced level.
Option 2: Store multiple text files
Store multiple text files (one per department) and host them in location with access control (e.g., SharePoint sites or folders with restricted access per department).
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.