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