Answered

Database size limit

(0) Share

Report

Posted on by gabimbola

Hello:

Is there a limit to the backend database size, for application written with PowerApps? I read PLAN 1 and PLAN 2 only allow for 20 MB & 250 MB respectively. I would like my database backend to be SQL Server, and I would like to write PowerApps that would be use by a lot of people. Please advise.

Thanks,

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like (2)

Report

There is no limit for a SQL database. The 20/250 MB limit has to do with the Common Data Service Database capacity.

Was this reply helpful? Yes No
gabimbola 21 on at

Like (0)

Report

Thank you very much.
GA.

Was this reply helpful? Yes No
v-xida-msft on at

Like (0)

Report

Hi @gabimbola ,

Have you solved your problem?

Currently, within PowerApps, there is no official document mentioned about the Database Size limit within PowerApps.

The 20 MB and 250 MB limit is only applied to Common Data Service data source within PowerApps. Please check the following article for more details:

https://powerapps.microsoft.com/en-us/pricing/#compare-plans

If you want to use SQL Server as your backend database, there are some known issue/limits you need to note:

https://docs.microsoft.com/en-us/connectors/sql/#known-issues-and-limitations

If you have solved your problem, please go ahead to click "Accept as Solution" to identify this thread has been solved.

Best regards,

Was this reply helpful? Yes No
David Jennaway 716 on at

Like (0)

Report

If the main data is to be stored in SQL Server in Azure, then there are several storage options but in practise these should be ample, as they are measured in GB. For OnPremise, you're mostly limited by disk space.

Note that the CDS storage is per user, so if you have a lot of users, you will have quite a lot of storage capacity

Was this reply helpful? Yes No
gabimbola 21 on at

Like (0)

Report

Thanks for your response.
GA

Was this reply helpful? Yes No