How long is it taking to return the 25 rows to Power Apps?
Is it filtering these rows from a larger data set in Power Apps?
How long does the same data take in SSMS?
Querying our on-prem data thru Power BI no issues. Only issue we see are thru power apps and DBogunovic who comment earlier is the creator of the power app.
It's hard to say what could be causing the slowness on the Power Apps side. Here is some documentation on tuning the data gateway
I would suggest enabling the additional logging if you haven't already. Then, pull the rows into Power Apps and look through the logs.
You can also do a SQL trace in the SQL Server Profiler, which I've used to tune some Power Apps query performance. That may not help you a lot unless your data is coming from a view or stored procedure, though.
If this answered your question, please click "Accept Solution". If this helped, please Thumbs Up.
Find your favorite faces from the community presenting at the Power Platform Community Conference!
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