cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Execute SQL Query(V2) error

When executing a query this error appear:

GhassSD_1-1600332516066.png

Any solution

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Execute SQL Query(V2) error

Hi @GhassSD 

 

The “Execute a SQL query” action is not currently supported in Microsoft Flow using an on-premises gateway connection. 

 

Please vote for this idea.

 

https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Support-quot-Execute-a-SQL-query-quot-actio...

 

Thanks

 

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials

View solution in original post

5 REPLIES 5
Highlighted
Super User II
Super User II

Re: Execute SQL Query(V2) error

Hi @GhassSD 

 

This can be anything. Can you please share the Power Automate and obfuscate anything private that you can't share so that I can have a better understanding of what you're trying to do and the issues.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Highlighted
Frequent Visitor

Re: Execute SQL Query(V2) error

Hi @manuelstgomes,

 

Thanks for your reply,

When i am trying to execute a SQL Query(V2) (wherever in the begin, middle or end of the flow), directly when i choose the database, this error appear

 

 

Highlighted
Super User III
Super User III

Re: Execute SQL Query(V2) error

Hi @GhassSD 

 

The “Execute a SQL query” action is not currently supported in Microsoft Flow using an on-premises gateway connection. 

 

Please vote for this idea.

 

https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Support-quot-Execute-a-SQL-query-quot-actio...

 

Thanks

 

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials

View solution in original post

Highlighted
Microsoft
Microsoft

Re: Execute SQL Query(V2) error

Hi @GhassSD 

 

You can try using "Execute Stored Procedure" Action instead, and convert the native query to stored procedures.

Also find below link for the Connector documentation and limits 
https://docs.microsoft.com/en-us/connectors/sql/#known-issues-and-limitations 

 

Best Regards

Mark 

Highlighted
Super User III
Super User III

Re: Execute SQL Query(V2) error

Hi @GhassSD 

 

If your problem has solved, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Users online (6,134)