Forum Discussion

bcdobbs's avatar
bcdobbs
Icon for Community Champion rankCommunity Champion
3 years ago

Dataflow Gen2 Issue

Hi,   I'm trying to run a very simple Gen2 Dataflow from an on prem sql server.   All setups fine but when I ask it to refresh I get: "Error: Couldn't refresh the entity because of an issue ...
Dataflows
SidJay's avatar
SidJay
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

There was a new version of the Gateway released today (May 30th). The version number is 3000.174.12. That version addresses the "We don't support creating directories in Azure Storage unless they are empty" error.

  • bcdobbs's avatar
    bcdobbs
    Icon for Community Champion rankCommunity Champion
    3 years ago

    I've updated to 3000.174.12.

     

    This has improved things in that the Gen2 Dataflow will now refresh when a destination is not specified. However if I ask it to write to the lake house I now get:

     

    “null Error: Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Details: DataSourceKind = Lakehouse;DataSourcePath = Lakehouse;Message = A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server);ErrorCode = -2146232060;Number = 53;Class = 20 GatewayObjectId: 2bcf3e12-740c-47e3-86f3-b94626567200. .”

     

    I wondered if I needed to configure the lakehouse connection to use the gateway but it won't let me do that.

     

    Ben

    • miguel's avatar
      miguel
      Icon for Community Admin rankCommunity Admin
      3 years ago

      When you're editing your dataflow, are you able to see the data from your SQL Server in there? Does your Server require IPs to be in an allow list? could it be the firewall at your data source level preventing the connection?

      • bcdobbs's avatar
        bcdobbs
        Icon for Community Champion rankCommunity Champion
        3 years ago

        It's not the on prem end causing the issue now. In Gen 2 Dataflows if I don't select a destination it pulls the data fine into its staging lake house. Problem occurs with selecting a destination (lakehouse).