Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Performance and security. Source Formula Source vs API. Alternatives?

Hi Guys 


I have the following question. I've experienced that when I a write a filter to retrieve the data from a source the response time is much slower than when  API is used. Now, for me, it's important to avoid using API's are public and I don't want to expose any data. Is there an alternative way where Can I have a similar or improved performance with the functions available in power apps without using an API? Do I have another alternative to API's to provide a secure and rapid response time? Thanks!

Community Support
Community Support

Hi @abecerra,


In addition to query the data from the data source, we could save the query locally in a collection.

Please take a look at the thread below:

Overcoming the 500 record limit locally



Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users


We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Top Solution Authors
Top Kudoed Authors
Users online (43,352)