Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that…

The goal is to minimize Dataverse storage consumption. While the File data type correctly utilizes the more cost-effective File storage instead of Database storage, it still consumes capacity within the Dataverse environment. The recommended and most effective solution for minimizing Dataverse storage for document management is to use the native SharePoint integration. This approach stores the actual files in SharePoint, which has a separate and often more generous storage capacity, while only storing a lightweight reference link within Dataverse. Therefore, using a File column does not meet the goal of minimization.

A. Yes: This is incorrect because the solution consumes Dataverse File storage. A superior method for minimizing storage, SharePoint integration, exists and is the recommended best practice for this scenario.

1. Microsoft Learn. (2023). Use the file data type. In Microsoft Dataverse developer guide. "A file is stored in Dataverse file storage

not in database storage

which can save you database storage costs."

Note: This reference confirms that the File type uses File storage. While better than database storage

it is still Dataverse storage.

2. Microsoft Learn. (2024). Free up storage space. In Power Platform admin documentation. Under the "How can I free up storage space?" section

it recommends: "Move data to another storage system. For example

for attachments

consider moving them to SharePoint and then just keeping a link in the Dataverse record to the SharePoint document."

Note: This explicitly states that moving attachments to SharePoint is a primary method for freeing up (and thus minimizing) Dataverse storage.

3. Microsoft Learn. (2023). Set up SharePoint integration. In Power Apps documentation. "With SharePoint Online

you can use the document management capabilities of SharePoint from within model-driven apps. You can store and manage documents in the context of a record on a SharePoint Server."

Note: This highlights the intended use of SharePoint for document management

which offloads the storage burden from Dataverse.