"An error occurred on the server. Service Response: [dbo].[tablename] failed: BadGatway"
I've never used Azure Synapse as a data source before but I have seen the error you have described in other situations. Typically it is associated with either their being some kind of overload on the call you are making to the data source or some kind of formatting error on the call itself. Without some kind or traces and understanding the Azure Synapse data system it is hard to say either way. This might be a better question for Microsoft Support. I will include a link below; on how to create a request with them. Otherwise if any other communities members might have any clues feel free to chime in.
If you would like to create a ticket with Microsoft Customer Support here is a link on how to do so: https://docs.microsoft.com/en-us/power-platform/admin/get-help-support
Community Support Team _ Alex Rezac
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate the response, Alex! I am testing with a simple 2 column table and error is consistent. I will ping MS and see what I hear. Will post the resolution here.
Following up to my own question in case someone have similar question.
Today, "Azure SQL Data Warehouse" connector allows you to connect to Azure Synapse and run SQL queries, stored procedures to perform CRUD (create, retrieve, update and delete). But the catch is, it is available only in Power Automate and not available in Power Apps. So, if you need to create an app against Azure Synapse you will have to call flow from apps to perform CRUD actions.
Microsoft documentation on: Azure SQL Data Warehouse
Hope someone finds this useful.
Check out the on demand sessions that are available now!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.
Features releasing from October 2020 through March 2021