topic Re: Dataflow Gen2 Issue: Cannot use Lakehouse datasource in dataflow gen2 in Fabric in Dataflow

Dataflow Gen2 Issue: Cannot use Lakehouse datasource in dataflow gen2 in Fabric

anuarmn — Fri, 26 May 2023 17:09:14 GMT

Background: I initially created dataflow gen2 and ingest data to Lakehouse. It is working fine.

However, when I created a new dataflow and trying to use to ingest data to same lakehouse, I got below error whenever trying to use the existing lakehouse datasource. I have tried deleting the Lakehouse datasource the original dataflow and still not working. Help!!

UPDATE 2023-05-26 : Turns out that this issue only happens if you are trying to ingest on-premise datasources via gateway. After updating the on-premise gateway to the latest version, you should be able to set the Lakehouse connection.

Re: Dataflow Gen2 Issue: Cannot use Lakehouse datasource in dataflow gen2 in Fabric

suidino2 — Thu, 25 May 2023 08:47:03 GMT

Facing the same problem here. I have tried several tenant, all same problem. Are we doing it in the wrong way? Or it just preview error? hope the develop team can solve this weekend...

Re: Dataflow Gen2 Issue: Cannot use Lakehouse datasource in dataflow gen2 in Fabric

FredrikJ — Thu, 25 May 2023 12:41:34 GMT

Yes, same issue here.

/Fredrik

Re: Dataflow Gen2 Issue: Cannot use Lakehouse datasource in dataflow gen2 in Fabric

anuarmn — Fri, 26 May 2023 06:43:58 GMT

Turns out that this issue only happens if you are trying to ingest on-premise datasources via gateway. After updating the on-premise gateway to the latest version, you should be able to set the Lakehouse connection.

Re: Dataflow Gen2 Issue: Cannot use Lakehouse datasource in dataflow gen2 in Fabric

RRPowerBiAdmin — Sat, 27 May 2023 21:50:51 GMT

It's doing it to me with no gateway needed. Even a simple self made table won't save to lake house because it won't store credentials.

Re: Dataflow Gen2 Issue: Cannot use Lakehouse datasource in dataflow gen2 in Fabric

miguel — Sat, 27 May 2023 22:35:39 GMT

That could be a different problem. I'd highly recommend reaching out to the customer support team for assistance to dig deeper into it, but the gateway related issue is unrelated to any sort of credential related one that could be happening in your scenario.

Re: Dataflow Gen2 Issue: Cannot use Lakehouse datasource in dataflow gen2 in Fabric

Anonymous — Tue, 30 May 2023 17:47:45 GMT

I was facing the same issue and updating the On Premise Data Gateway solved the issue. Muchios Gracias for sharing the solution.

Re: Dataflow Gen2 Issue: Cannot use Lakehouse datasource in dataflow gen2 in Fabric

LP13 — Mon, 12 Jun 2023 05:04:09 GMT

Hi anyone,

While it appears that the solution to this is to update on-premise data gateway to the latest version 3000.174.13, I am still facing the same issue as desribed in thi thread, regardless is to connect to data source or to connect to data destination.

May I ask if this has anything to do with the region? Thank you.

Re: Dataflow Gen2 Issue: Cannot use Lakehouse datasource in dataflow gen2 in Fabric

Bertie1 — Sun, 18 Jun 2023 15:55:54 GMT

Hi,
Have you been able to solve your issue suidino2 or FredrikJ ?
I also have updated the gateway to try but my data source is actually from an sql server and not on premise. So I don't believe that has anything to do with this.

Re: Dataflow Gen2 Issue: Cannot use Lakehouse datasource in dataflow gen2 in Fabric

suidino2 — Sun, 18 Jun 2023 16:01:49 GMT

Yes, currently I am using gateway version, [3000.174.13], having no problem. I think the problem came up when I was using the previous version of [3000.178.??] gateway.