Dynamics 365 – File Storage and Business Central

Getty Images

For Business Central online, there is a limit to how much data we allow each tenant to store in the environment (database). If a tenant exceeds this limit, we contact the partner and work with them to reduce the size of the data. The limit for the size of each environment’s data in Business Central is currently set to 80 GB.

Although a soft limit of 80 GB, there are solutions to minimise the risk of reaching or exceeding this limit. There are multiple ways to store your files in the cloud while making them available to our Business Central, 3 ways are discussed below. While these solutions a targeted for Business Central you can also use them in all other NAV implementations.

Storing the files inside the database. This solution is by far the simplest to implement, it also has drawbacks, the first of which is that storing files inside your database can cause it to increase in size and affected performance. Business Central is an ERP and not a file storage. While it is possible to store your files inside your database, it is not recommended.

Azure blob storage. Similar to SharePoint but without all the jazz. SharePoint provides a very simple file storage, which very much is its strength. Additionally, it is simple to use. To create blob storage all you have to do is go to Azure portal and select create. Additionally, the blob storage provides a simple REST interface, which can be used to access the saved files. A sub-option is to create a Azure function to handle all communication with storage, have a simple interface, create multiple functions (i.e. one for Business Central, one for CRM). 

OneDrive / SharePoint. This solution requires SharePoint subscription. Microsoft Graph can be utilised to share files across all platforms. “Microsoft Graph is the gateway to data and intelligence in Microsoft 365. It provides a unified programmability model that you can use to access the tremendous amount of data in Office 365, Windows 10, and Enterprise Mobility + Security. Use the wealth of data in Microsoft Graph to build apps for organizations and consumers that interact with millions of users.”

https://docs.microsoft.com/en-us/graph/overview

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/faq#how-does-microsoft-handle-database-sizes

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s