How cn i restrict someone from not downloading any data from Fabric Lakehouse or Fabric warehouse

Jain, Shreyans 0 Reputation points
2024-11-05T05:24:13.73+00:00

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:

  1. 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.
  2. 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.
Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,495 questions
Microsoft Fabric Training
Microsoft Fabric Training
Microsoft Fabric: A Microsoft unified data platform.Training: Instruction to develop new skills.
51 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Smaran Thoomu 17,520 Reputation points Microsoft Vendor
    2024-11-05T15:42:17.7+00:00

    Hi @Jain, Shreyans

    Thanks for the question and using MS Q&A platform.

    MS Fabric 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 Fabric community forum.

    Can you please open as a new thread in MS Fabric community: https://community.fabric.microsoft.com/t5/General-Discussion/bd-p/ac_generaldiscussion

    User's image

    Hope this helps. Do let us know if you any further queries.


    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.