Forum Discussion

MOVC's avatar
MOVC
Icon for Resolver I rankResolver I
2 years ago

Dataflow Gen2 Failure: Couldn't refresh the entity, transport-level error

This morning one of our Gen2 Dataflows began failing. It takes data from our On Prem SQL Server via the Data Gateway and creates a new table in a Warehouse with the replace method. The error message ...
Dataflows
Need Help
v-cboorla-msft's avatar
v-cboorla-msft
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago

Hi MOVC 

 

Thanks for using Microsoft Fabric Community.

Apologies for the inconvenience that you are facing here.

When using Microsoft Fabric Dataflow Gen2 with an on-premises data gateway, you might encounter issues with the dataflow refresh process. The underlying problem occurs when the gateway is unable to connect to the dataflow staging Lakehouse in order to read the data before copying it to the desired data destination. This issue can occur regardless of the type of data destination being used.

To troubleshoot the issue kindly refer to the documentation for details.

 

I hope this informatoin helps. Please do let us know if you have any further questions.

 

Thanks.

MOVC's avatar
MOVC
Icon for Resolver I rankResolver I
2 years ago

Thank you for the reply, but I am able to create new gen 2 dataflows copying data via the gateway to warehouse in new workspaces without issue so I don't believe that this is the problem.

  • MOVC's avatar
    MOVC
    Icon for Resolver I rankResolver I
    2 years ago

    Further testing:

     

    If I create a new Warehouse and a new Dataflow gen2 in the same workspace as the original version, then I get the same error message. However if I use a brand new workspace with the same dataflow query and a new warehouse then it works. 

    Could there be an issue with the Staging Lakehouse in that Workspace?

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

      Hi

      Please go ahead and raise a support ticket so an engineer can take a closer look at this situation.

      https://support.fabric.microsoft.com/support

       

      If you've isolated the issue to a particular workspace, then this would require an investigation by our support ticket.

      • MOVC's avatar
        MOVC
        Icon for Resolver I rankResolver I
        2 years ago

        I have created the ticket.