Forum Discussion

Subha45's avatar
Subha45
Regular Visitor
11 months ago
Solved

Writing data into a ADLS Gen 2 container directly from fabric notebook

Hi,   I have a scenario where I need to write a pyspark dataframe into a storage account container directly.  The fabric has Storage Blob Contributor permission over the container , however I am st...
data engineering
environment
lakehouse
notebook
User Data Functions
  • v-prasare's avatar
    v-prasare
    11 months ago

    Hi Subha45,

    Even with RBAC roles like Storage Blob Contributor, ADLS Gen2 also requires filesystem-level ACLs.

    • Go to the Data Lake container in Azure Portal. Check the Access Control List (ACL) on the folder you're writing to, Ensure the Managed Identity of the Fabric workspace has rw (read/write) permissions.
    • Sometimes, trying a read operation first can help confirm whether it's a write-specific permission issue.
    • If you're unable to modify ACLs or confirm the identity:

    Continue using the Lakehouse shortcut, which handles permissions internally in Microsoft Fabric for secure and seamless access.

     

     

     

     

    Thank you for your patience and look forward to hearing from you.
    Best Regards,
    Prashanth Are
    MS Fabric community support

Subha45's avatar
Subha45
Regular Visitor
11 months ago

Hi BhaveshPatel 

 

Thanks for the reply but due to some client security it's difficult for me to get the screenshots , however I can elaborate the situation. 

I am trying to save a dataframe from notebook into a storage container folder as a file.

It's working saved if I have a shortcut to the location and uses the abfss path.

While when I am directly addressing the storage container folder using abfss path without any shortcut it's throwing the error as 403 : The request doesn't have the permission as an error. 

So was wondering if we can only write into a ADLS gen 2 location only using the lakehouse shortcut reference through notebook or is there a way to write into the location directly