Forum Discussion

AnkitKukreja's avatar
AnkitKukreja
Super User
5 years ago
Solved

Create a Dataflow with Azure Data lake storage Gen 2 connection

Hi!
I want to create a data flow with ADLS Gen2. I have the connection in pbix but when I create a dataflow in Service, it throws an invalid credential error with the session id.
I'm not sure if I'm missing anything on service. My dataflow option is enabled in the settings.

 

My question is my workspace is connected to another data lake in the premium capacity. But, this is a different data lake. 
Can I create a data flow from another ADLS in the current workspace or I need another workspace?

 

Best,
Ankit

  • Hi AnkitKukreja ,

     

    >>  But, this is a different data lake. 
    Can I create a data flow from another ADLS in the current workspace or I need another workspace?

     

    Yes, you can . you don't need another workspace.  To give access to dataflows in other workspaces to use the output of a dataflow in a workspace, you just need to give them View access in the workspace. 

     

    Please refer to https://docs.microsoft.com/en-us/power-query/dataflows/best-practices-reusing-dataflows

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

1 Reply

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Community Support

    Hi AnkitKukreja ,

     

    >>  But, this is a different data lake. 
    Can I create a data flow from another ADLS in the current workspace or I need another workspace?

     

    Yes, you can . you don't need another workspace.  To give access to dataflows in other workspaces to use the output of a dataflow in a workspace, you just need to give them View access in the workspace. 

     

    Please refer to https://docs.microsoft.com/en-us/power-query/dataflows/best-practices-reusing-dataflows

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai