Forum Discussion

cassidy's avatar
cassidy
Icon for Power Participant rankPower Participant
3 years ago

Dataflow Gen2 Issue

When trying the new "Dataflow Gen2", an error of "There was a problem refreshing the dataflow. Please try again later. (Request ID: aa7e41ba-d6a9-47df-8d67-e5a3c98146b2)." persists.   To test, I ha...
Dataflow
Need Help
DenisLux's avatar
DenisLux
Frequent Visitor
3 years ago

I also have the same issue but I noticed a few particularities:

1) If I create dataflow Gen2 with source from Sharepoint and destination to Warehouse/Lakehouse -> it works

2) If in the same dataflow I add another source from Azure SQL via gateway -> both queries work for tables update but now fail with wiring to destination (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)
3) If now I delete second query and leave initial one (which was working), it doesn't work anymore and gives the same error while trying to write to Warehouse.
It seems that if there is gateway in the source -> dataflow loses connection to Warehouse/Lakehouse (even if they are in the same worspace)