Dataflow Gen2 with ODBC Source from onPrem Gateway fails

Hi Data-Crunch ,

Thanks for reaching out to the Microsoft fabric community forum. Also thank you vivien57  for your response.

Your gateway version (3000.182.5) is current, so the “unsupported version” error may be related to the gateway mode or registration. Please confirm it’s set to Fabric mode and try a clean reinstall if necessary. Also, check that TCP 1433 access to *.fabric.microsoft.com and *.dfs.fabric.microsoft.com is enabled, though network issues are unlikely since single queries are publishing successfully.

Note that Dataflow Gen2 has limitations with multi-query references when using ODBC sources, which can lead to publishing or refresh errors. To diagnose, enable both gateway logs and Dataflow diagnostic logs. As a workaround, consider splitting complex queries into separate dataflows and combining results later, so each can refresh on its own.

Hope this helps. Please feel free to rech out for any further questions.

Thank you .