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

[anuarmn]

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.

[optimizer]

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

[anuarmn · Accepted solution]

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.

[RRPowerBiAdmin]

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. 

[miguel]

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.

[FredrikJ]

Yes, same issue here.

/Fredrik

[suidino2]

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...