Building an app in Power Apps with Sql Server on premise as a backend - Pros and Cons

(2) Share

Report

Posted on by naijacoder

178

Hi All,
I'm about to kick start on a project and looking for honest advises etc...
The current application was built on an old asp.net framework with sql server on premise as its backend.
We are thinking of rewriting it to use Power apps and still use the sql server as the datasource.
Is this a good? I know we will need to purchase premium connectors but also thinking about the connection (Data Gateway that needs to be setup).
Will this reduce load speed?
Are there many limitations we need to think of?
If you have built any app using Power Apps and Sql sever on premise I would love to hear you feedback

Thanks

Categories:

Building Power Apps

General topics

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

MS.Ragavendar 7,431 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@naijacoder,

What is the volume of data which you going to store and retrieve from the SQL Database?

How many users you are going to consume? (More users needs each one license so cost involved).

Is this a good? I know we will need to purchase premium connectors but also thinking about the connection (Data Gateway that needs to be setup).

It depends on the complexity, but generally Great for simple CRUD-style, forms-based apps.

Yes you can connect using gateways and SQL Server is a premium connector you need license too.

Are there many limitations we need to think of?

Power Apps can read SQL views, but you cannot update data via sql views.

By default only 2000 rows but you can extend using some pagination mechanism.

Multi user edit are not possible (concurrency).

Storing the files and Images - you need to convert it to binary and need to store.

Suggestions based on my experience

If you have organization M365 license, you can look for migrating the SQL data to SharePoint Online (DataSource / Database) which will reduce your license and cost issues.

Handling files is easier in the sharepoint document library or list item attachments.

✅ Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.

❤️ Please consider giving it a Like, If the approach was useful in other ways.

🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.

1 people found this reply helpful.

Was this reply helpful? Yes No
naijacoder 178 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your responses MS.Ragavendar

Was this reply helpful? Yes No
MS.Ragavendar 7,431 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@naijacoder,

If your query is addressed will you able to mark the proposed answer as verified which will also close the thread

If you still have any queries or clarification.

🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.

Was this reply helpful? Yes No