MS Fabric - Dataflow Gen 2 - Load On-Premise Oracle/MS SQL to Lakehouse error

[DavidPi]

Hello,

I tried to load Oracle/MS SQL data through on-premise gateway in Dataflow Gen. 2.. I see tables, load table in editor, see columns, data. Then I wanted to set destination to Lakehouse and always receive this error message:

An exception occurred: The given data source kind is not supported. Data source kind: Lakehouse. 

I tried csv file from SHP - and this was ok, I was able to load data to Lakhouse.

I know - MS Fabric is in preview - but I can not find that this feature (Oracle/MS SQL on-premise) is not yet supported. 

Thanks.

[Thomas_Duc]

I have the exact same problem with a dataflow gen 2 loading data through an entreprise data gateway. It's impossible to set data destination to Lakehouse.
Same error message : "An exception occurred: The given data source kind is not supported. Data source kind: Lakehouse. "

[macmy034]

It appears as though you can't push data from a local SQL server to the lakehouse - pretty dang annoying.

[v-xiaoyan-msft]

Hi  @all,

In order to better investigate your problem, could you provide detailed reproduction steps and information about your version (including the version of the gateway)?

Best regards.
Community Support Team_Caitlyn

[DavidPi]

Hi,

gateway version: 3000.166.9

Steps:
- I enable MS Fabric on capacity level
- Create new workspace
- Create new Lakehouse
- Create new Dataflow
- Get Other Data > Oracle > Fill server name and select our enterprise gateway > Next
- Select Table > Create
- See table and data
- Add destination Lakehouse > Connection Lakehouse (none) > Next > Receive Error Message

[Noeleke1301]

@DavidPi I had the same error when I tried loading our on-prem Oracle data into a lakehouse. Was running gateway version of March.

Just updated the gateway to the latest version and now it works.

[DavidPi]

Thx, I will ask our IT OPS to upgrade gateway and let you know.

[v-jingzhang]

Hi @DavidPi 

Is there any update? Have you upgraded gateway to the latest version and set destination to Lakehouse successfully?

This issue is due to that the earlier versions of gateway don't support Lakehouse connectivity. But from the On-premises data gateway May 2023 release, we have added support for Lakehouse connectivity over the gateway. Update to the latest version to be able to load your on-premises data into a Lakehouse.

Best Regards,
Community Support Team _ Jing

[DavidPi]

We installed new gateway. Now we are able to prepare dataflow gen 2 - I can see lakehouse destination, select our lakehouse, select option create new table and append.

I published dataflow. 

But when running I received this another error message:

[DavidPi]

Any news?

Detail Error is here.

What is suprising - I can see my table in DataflowsStagingLakehouse. So data was loaded to DataflowsStagingLakehouse but could not be loaded to my Lakehouse. I don't understand the reason.

[macmy034]

This seems so weird to me, are other people using it with On Prep SQL Ingestion without issue? They must be if its only us having this issue....