Forum Discussion

molegris's avatar
molegris
Icon for Advocate IV rankAdvocate IV
1 year ago
Solved

How to set ADLS as a destination in Dataflows Gen 2 ?

Hi, I did what I thought was the complete setup to be able to save data tables in an ADLS Gen 2 but it still doesn't work. Can someone help me find the part I'm missing please?   Here's what I did...
Dataflow
Need Help
  • Poojara_D12's avatar
    Poojara_D12
    1 year ago

    Hi molegris 

    Fabric writes data to OneLake by default, even if ADLS Gen2 is connected.

    To resolve:

    Check ADLS Gen2 Permissions: Ensure the user has Storage Blob Data Contributor access.

    Direct Write to ADLS: Not supported; use Azure Data Factory or scripts to sync OneLake data to ADLS Gen2.

    Verify Hierarchical Namespace: Confirm it’s enabled for ADLS Gen2.

    Export Data: Use tools to move data periodically from OneLake to ADLS Gen2.

     

    Fabric doesn’t mirror data to ADLS Gen2 automatically; external sync is required.

     

    Did I answer your question? Mark my post as a solution, this will help others!

    If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

    Kind Regards,
    Poojara
    Data Analyst | MSBI Developer | Power BI Consultant
    Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS 

Poojara_D12's avatar
Poojara_D12
Icon for Super User rankSuper User
1 year ago

Hi molegris 

Fabric writes data to OneLake by default, even if ADLS Gen2 is connected.

To resolve:

Check ADLS Gen2 Permissions: Ensure the user has Storage Blob Data Contributor access.

Direct Write to ADLS: Not supported; use Azure Data Factory or scripts to sync OneLake data to ADLS Gen2.

Verify Hierarchical Namespace: Confirm it’s enabled for ADLS Gen2.

Export Data: Use tools to move data periodically from OneLake to ADLS Gen2.

 

Fabric doesn’t mirror data to ADLS Gen2 automatically; external sync is required.

 

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS 

molegris's avatar
molegris
Icon for Advocate IV rankAdvocate IV
1 year ago

Hi Poojara_D12 ,

Thanks for your reply.

 

I have follow-up question though.  Since ...

 

Direct Write to ADLS: Not supported; use Azure Data Factory or scripts to sync OneLake data to ADLS Gen2.

 

Then do you know a situation where setting up an Azure connection in a Power BI / Fabric Workspace would be advantageous?

 

Best regards,

--mo