cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gabimbola
Frequent Visitor

Database size limit

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,

GA

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Database size limit

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



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

View solution in original post

5 REPLIES 5
Super User
Super User

Re: Database size limit

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



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

View solution in original post

gabimbola
Frequent Visitor

Re: Database size limit

Thank you very much. 

GA. 

Community Support
Community Support

Re: Database size limit

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
DavidJennaway Responsive Resident
Responsive Resident

Re: Database size limit

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

gabimbola
Frequent Visitor

Re: Database size limit

Thanks for your response.

GA

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Attending MBAS? Claim your badge

Attending MBAS? Claim your badge

Whether you’re streaming the digital event live, or watching on-demand, claim your attendee badge to sport on your profile.

‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Power Platform 2020 release wave 1 plan

Power Platform 2020 release wave 1 plan

Features releasing from April 2020 through September 2020

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We're launching a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Emergency Response & Monitoring Solution

Emergency Response & Monitoring Solution

Microsoft has created a regional government emergency response and monitoring solution that is built on Power Apps and Power BI.

Top Solution Authors
Top Kudoed Authors
Users online (6,017)