Forum Discussion
DataSource.Error (401) when trying to connect to Lakehouse from within a Dataflow Gen2
Hello v-venuppu ,
thanks for your support. While your solution did not fix my problem it motivated me to try one more thing, which finally solved to problem:
I think my issue is related to my company having muliple tenants and the tenant where the fabric capacity/workspace is located in is not the native tenant of my user. We now created a new native user within the fabric tenant and gave it admin permissions to the workspace. When I log in with this user I can create connections to lakehouses. After sharing the connections, I can re-use them also with my normal user
Community SupportHi philip_gen2 ,
Thank you for reaching out to Microsoft Fabric Community.
Thank you Anonymous Youraj8271 for the prompt response.
This issue is caused by a known authentication limitation in Dataflow Gen2. Even if you are a Workspace Admin, Dataflow Gen2 still requires explicit item-level permissions on the Lakehouse.
To fix the 401 error, go to the Lakehouse --> Manage permissions --> add the user directly --> give Contributor or Admin.Once the Lakehouse has direct item permissions, the Dataflow Gen2 connection should work normally.
Hello v-venuppu ,
thanks for your support. While your solution did not fix my problem it motivated me to try one more thing, which finally solved to problem:
I think my issue is related to my company having muliple tenants and the tenant where the fabric capacity/workspace is located in is not the native tenant of my user. We now created a new native user within the fabric tenant and gave it admin permissions to the workspace. When I log in with this user I can create connections to lakehouses. After sharing the connections, I can re-use them also with my normal user