Understanding Dataverse Storage: From Business Basic to Power Apps Licenses


When I started exploring Microsoft Power Platform with just a Microsoft 365 Business Basic license (primarily for business email via Outlook), I noticed some limitations when trying to create environments for Power Apps development.

Starting Point: Developer Environments Only

Even without any Power Apps licenses, I was able to create multiple Developer environments. However, when I checked the Resource Capacity in the Power Platform Admin Center, I discovered the following:

  • Database and file storage: 0 MB available
  • Storage usage display: No usage shown, even with Developer environments created



This aligns with how the Power Apps Developer Plan is designed. It's tailored for personal learning and development, not for Production use. The default limits are:

CapacityLimit
Flow runs/month750
Database size2 GB

⚠️ However, these resources are tied to personal use and do not contribute to tenant-wide capacity. You can’t create Production environments under this plan.

Adding Licenses: Unlocking Capacity

📘 Note on base capacity: According to Microsoft’s official documentation, each tenant receives 10 GB of Dataverse database capacity when at least one Power Apps per user (Premium) or Dynamics 365 per user license is assigned. Before assigning any eligible license, the tenant has 0 GB of Dataverse capacity for Production or Sandbox environments. This is by design and consistent with the experience I had.

✅ Power Apps Premium (Per User) License

Once I added one Power Apps Premium license:

  • Database capacity increased by 10 GB + 256 MB (per license)
  • File storage increased by 2 GB (per license)




✅ Power Apps Per App License

After purchasing a Power Apps Per App license:

  • Database storage increased by 50 MB (per license)
  • File storage increased by 400 MB (per license)



📌 According to Microsoft’s official documentation, the Power Apps per app plan grants 50 MB database and 400 MB file capacity per license.



Final Outcome: Creating Production and Sandbox Environments

With these licenses and increased capacity, I successfully created:

  • A Production environment
  • A DEV (Sandbox) environment

Both of which now appear in the capacity usage breakdown:



Summary

License TypeDatabase Capacity (per license)File Capacity (per license)
Power Apps Premium10 GB + 256 MB2 GB
Power Apps Per App50 MB400 MB

If you're starting with only a Business Basic license, be aware:

  • You can build and test in Developer environments
  • You cannot create Production environments until you add appropriate licenses
  • License purchases directly contribute to Dataverse capacity

💡 Tip: Start with a Premium license to unlock Production capabilities, and layer additional Per App licenses if needed for specific deployments.

I hope this helps anyone navigating Microsoft Power Platform storage limitations and license planning!

No comments:

Post a Comment