web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Slow or failed return ...
Power Apps
Answered

Slow or failed return when running query to on-premise sql server

(0) ShareShare
ReportReport
Posted on by 34

I'm having an issue when i run one query from my on prem SQL server.  This same statement has been working fine for many months but all of a sudden can take up to a minute to return a result.   When the statement (using the same parameter) is run from my SQL studio, it takes 3 seconds to complete. 

None of my other queries respond like this.

I've tried deleting the connection and re-adding it.  I've even tried running it from a different environment with a whole different Connector... I get the same result. 

Has anyone else had a similar issue?   I'm at a loss.

 

 

Categories:
I have the same question (0)
  • Verified answer
    v-jefferni Profile Picture
    on at

    Hi @cpolito ,

     

    If I understand correctly, you have only one query return results slowly or even failed, while other queries which using same gateway connect to the same table in that on-premise SQL Server all worked fine?

     

    If so, it's hard to tell what the problem is. If the issue persists for long term, maybe you'd better rise a ticket on support page for more support:

    https://powerapps.microsoft.com/en-us/support/

     

    Hope this helps.

     

    Best regards,

    Community Support Team _ Jeffer Ni
    If this post helps, then please consider Accept it as the solution to help the other members find it.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 721 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 320 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard