topic Re: Dataflow Gen 2 : Lakehouse connector doesn't work in Dataflow

Dataflow Gen 2 : Lakehouse connector doesn't work

Joh24 — Wed, 13 Mar 2024 09:41:35 GMT

Hello,

It's been days since I try to use the Lakehouse connector with a dataflow gen2. When I try to select the lakehouse I want to connect to, the cursor goes round and round for minutes and I get this error :

Do you know if I need to do some complementary configurations to resolve that issue please ?

Notes : Both Lakehouse and dataflow originate from the same workspace; I use a trial Fabric

Re: Dataflow Gen 2 : Lakehouse connector doesn't work

v-cboorla-msft — Wed, 13 Mar 2024 10:46:21 GMT

Hi Joh24

Thanks for using Microsoft Fabric Community.

Apologies for the inconvenience that you are facing here.

As I understand that you are encountering a connection issue with the Lakehouse connector with a dataflow Gen2 in Microsoft Fabric.

To diagnose the cause of the connection error and establish a successful connection, please review these troubleshooting steps:

Temporary glitch : Clearing your browser's cache and cookies can sometimes fix connection problems. This is because it removes temporary files that might be outdated or causing conflicts. Try it, then restart Fabric and reconnect to the Lakehouse.

Review Authentication Types : Ensure compatibility between the authentication method you've chosen for the Azure Blob Storage connector is compatible with both the Copy Activity and Dataflow Gen2 activities.

Please refer for more details : Set up your Lakehouse connection.

Check the Gateway Configuration : For successful data transfer, confirm that the firewall on the server running the on-premises data gateway allows outbound traffic on port 1433 (TCP) to the following endpoints: *.datawarehouse.pbidedicated.windows.net, *.datawarehouse.fabric.microsoft.com, *.dfs.fabric.microsoft.com

For more details please refer : Set new firewall rules on server running the gateway

I hope this information helps. Please do let us know if you have any further questions.

Thanks.

Re: Dataflow Gen 2 : Lakehouse connector doesn't work

v-cboorla-msft — Thu, 14 Mar 2024 12:05:16 GMT

Hi Joh24

Thanks.

Re: Dataflow Gen 2 : Lakehouse connector doesn't work

v-cboorla-msft — Mon, 18 Mar 2024 10:07:11 GMT

Hi Joh24

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
If you have any question relating to the current thread, please do let us know and we will try out best to help you.
In case if you have any other question on a different issue, we request you to open a new thread.

Thanks.

Re: Dataflow Gen 2 : Lakehouse connector doesn't work

Joh24 — Mon, 18 Mar 2024 16:12:10 GMT

Hello,

Thank you for your help.

I tried these recommandations but it was still not working.
So I reached the support and after some verifications it was said that I can't use these gen2 dataflows since I am using a guest account. This is not mentioned in the official documentation but seems like an issue that has been reported before.

Re: Dataflow Gen 2 : Lakehouse connector doesn't work

miguel — Mon, 18 Mar 2024 16:35:17 GMT

Thank you for sharing this. I've passed this feedback internally to the product group.

Re: Dataflow Gen 2 : Lakehouse connector doesn't work

TimWrighty — Mon, 06 Jan 2025 10:42:25 GMT

I'm still seeing this issue in 2025! does anyone know if this is going to be fixed?