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
v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
3 years ago

The underlying issue is that the data gateway cannot connect to the dataflow staging LakeHouse in order to read the data before copying it to the desired output destination. Reading data from a lakehouse uses TCP over port 1433, which is used to copy the data from the staging lakehouse to the output destination. So the firewall rules on the data gateway server and/or customer's proxy servers need to be updated to allow outbound traffic from the data gateway server to the following

Protocol: TCP
Endpoint: *.datawarehouse.pbidedicated.windows.net
Port: 1433

 

When you use the same data gateway for Power BI and Data Factory with no issues, it is because their traffics flow to different Endpoints or they use different protocols/ports that are not blocked on the data gateway server.

 

Best Regards,
Community Support Team _ Jing

Anonymous's avatar
Anonymous
Not applicable
2 years ago

You saved my day! My firewall was filtering the traffic flow you mention!