Power app to on prem SQL taking too long to return rows.

[swoodsNACoal]

My power apps form taking too long to return 25 rows of data.  I need help trouble shooting issue, please contact me or what number can I call for support?

[EricLott]

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?

[swoodsNACoal]

it took me 50 seconds to return 16 rows. other times it will take over 1 min.

[swoodsNACoal]

I forgot to include not filtering talking place and querying to data in SQL is quick.

[dbogunovic]

In SSMS takes about second to retrieve the same number of rows.

[EricLott]

Is this true with all data coming through your on-prem gateway or just one specific data set?

[swoodsNACoal]

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.

[EricLott]

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

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-performance

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.

https://docs.microsoft.com/en-us/sql/tools/sql-server-profiler/sql-server-profiler?view=sql-server-v...

---
If this answered your question, please click "Accept Solution". If this helped, please Thumbs Up.