How cn i restrict someone from not downloading any data from Fabric Lakehouse or Fabric warehouse
As a data admin, i want to control data access for a user in your Microsoft Fabric Warehouse. The goal is to allow this user, who has a Contributor role, to view data directly in the workspace without being able to download it as a file. This scenario is critical for safeguarding sensitive data and preventing unintended data exports, especially when external contributors or junior team members need access to certain datasets but shouldn’t download them for compliance or confidentiality reasons.
Task Objective
My objective is to configure permissions and apply access restrictions so that:
- The Contributor can:
- View data tables and query data directly within the warehouse environment.
- Interact with tables to make necessary modifications, such as updating values or adding rows, but only as needed for their project without being able to extract the data offline.
- View data tables and query data directly within the warehouse environment.
- The Contributor cannot:
- Download or export the data in any form (e.g., CSV, Excel, or any other downloadable format).
- Use tools or methods (such as third-party extensions) to bypass the restriction and export data.