Forum Discussion

alfBI's avatar
alfBI
Icon for Responsive Resident rankResponsive Resident
2 years ago
Solved

Problem to import on premise data onto a lakehouse using a DataflowGen2

Hi,   I am trying to load data from an on premise SQL Server onto a Fabric lakehouse using a Dataflow Gen2.   We have alreday in place a on-premise gateway with the most updated release (November...
Dataflows
alfBI's avatar
alfBI
Icon for Responsive Resident rankResponsive Resident
2 years ago

Hi,

 

Effectively there was a problem on the config file "Microsoft.Mashup.Container.NetFX45.exe" never noticed before until now (we have started to use the gateway to load dataflows).

 

Once fixed we are finally to connect lakehouse to destination, (but with lot of patience, the message below "Validating Connection" appeared during more than 2 minutes....

 

 

once completed, navigation across workspaces to reach the lakehouse was extremely slow and once the lakehouse was selected it took a long time to create the table (> 2 min).

 

 

So, more than 5 min only to have the dataflow ready......Finally despite the fact that the dataflow was published following error does appear when executed

 

 

 

What are we doing wrong here? Access to  *.datawarehouse.pbidedicated.windows.net is already enable on our firewall...... Sounds we are each time closer but not enough 🙂

 

 

Many Thx

  • dazhang's avatar
    dazhang
    Icon for Microsoft Employee rankMicrosoft Employee
    2 years ago

    Hi Alfons,

     

    "The value is not updateable" is an issue that we just published a fix for today, would you mind upgrading to the latest version of the on-premises data gateway (3000.198.17) and try refreshing your dataflow again?

     

    Thanks,

    David