Forum Discussion

AnthonyGenovese's avatar
AnthonyGenovese
Resolver III
3 years ago

Transport-level Error using Dataflows Gen2

We are starting to receive the following error when running a dataflow gen 2 to the from on prem SQL Server to the lakehouse.     Mashup Exception Error Couldn't refresh the entity because of an i...
Dataflows
Need Help
motoray's avatar
motoray
Advocate V
2 years ago

This is finally working--going directly from on-prem SQL to a warehouse--for me. The first time I run to load data to a new table, I have to limit the load to just a few rows or I get the transport-level error. Once the new table is in the warehouse, though, I can load the full 5 million plus row dataset.

AnthonyGenovese's avatar
AnthonyGenovese
Resolver III
2 years ago
What version is your gateway?
  • motoray's avatar
    motoray
    Advocate V
    2 years ago

    3000.186.18

    • PaulCH's avatar
      PaulCH
      Frequent Visitor
      2 years ago

      Interesting! I had a note from the guys handling our support ticket yesterday to give things another try, but it still resulted in a failure after 6 hours (this is moving a table from a lakehouse to a warehouse in the same workspace).

      Also, I'm not sure about anyone else, but we don't get 'transport-level' errors anymore, we now get "There was a problem refreshing the dataflow". Symptoms are the same though.

      • motoray's avatar
        motoray
        Advocate V
        2 years ago

        I haven't tried moving data from Lakehouse to Warehouse. How big is your dataset?