Menu
I tried to execute a SQL query using Azure "On-Premises data gateway" from Azure Logic Apps. Running the logic resulted the following error message:
{ "status": 400, "message": "Gateway GetPassThroughNativeQueryMetadataAsync - this operation (Execute Native SQL) is currently not supported using an on-prem gateway connection\r\nclientRequestId: ...", "source": "sql-scus.azconn-scus.p.azurewebsites.net" }
There should be something wrong with my setup. If not, what's the point of having "Execute a SQL Query" if there is no support for native SQL queries? What am I doing wrong?
797
In the Azure portal, open your logic app workflow in the designer. Find and select the SQL Server action that you want to use. Under the trigger or action where you want to add the SQL Server action, select the plus sign (+), and then select Add an action.
The gateway works as a bridge that provides quick data transfer and encryption between data sources on premises and your logic apps. You can use the same gateway installation with other cloud services, such as Power Automate, Power BI, Power Apps, and Azure Analysis Services.
According to the documentation:
SQL native query is not supported for on-premises SQL server.
So this feature is not available at this point.
52
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
