Unanswered

To handle large dataset(in millions) in PowerApps using SQL server

(1) Share

Report

Posted on by Laxmikant_Alle

Hi All,

I have to use 1 million of records on monthly basis into my canvas application using SQL server, this application work for 1 year, which means 12 million records, And I also want to do CURD operations on that large data.

Is there any solution for this kind of approach?

Is it possible to create this kind of application using SQL server as data source in Canvas app?

Thanks in Advance

Regards,

@Laxmikant_Alle

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

timl 36,393 Super User 2025 Season 2 on at

Like (4)

Report
@Laxmikant_Alle

It's possible to build a canvas app that connects to a large SQL database with 12 million records.

For best performance:

Use delegable operators when searching or displaying data in gallery controls

If you want to join multiple tables, create SQL Server views rather than build formula in Power Apps that calls multiple Lookups

To bulk update/delete records, consider building SQL stored procedures and calling them via Flow.

Was this reply helpful? Yes No
takolota1 4,974 Moderator on at

Like (0)

Report

Anyone doing something like this could also try using this batch SQL CRUD template:

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/SQL-Batch-Create-Read-Update-and-Delete/td-p/1715338

Was this reply helpful? Yes No
takolota1 4,974 Moderator on at

Like (0)

Report

And now I built a custom connector for this:

https://powerusers.microsoft.com/t5/Community-App-Samples/SQL-Batch-Create-Read-Update-and-Delete-Custom-Connector/td-p/1744914

Was this reply helpful? Yes No