How to Choose Between Dataverse Standard and Custom Tables
Question details
The user wants to understand the differences between standard and custom tables in Dataverse, when to use each, and how to verify if a specific table was created by Dynamics 365 or an installed add-on.

- Product
- Microsoft Dataverse
- Device & OS
- not provided
- Scenario
- Deciding whether to use an existing standard table or create a new custom table to organize business data efficiently without reinventing the wheel.
- Observed behavior
- Users need clarification on identifying table types via logical names and prefixes, and locating the source of tables like Functional Locations.
Ensure you have the necessary System Administrator or System Customizer security roles in your Power Apps or Dynamics 365 environment to view table properties and inspect installed solutions.
Identify and Choose Between Standard and Custom Tables
Understand the defining characteristics of standard and custom tables to make the best structural choice for your business data.
Standard tables are created by default with the Dataverse database and cover common business concepts like Account, Contact, and User. Custom tables are added manually later to address specific organizational requirements that standard tables cannot fulfill.
Always check if a standard table (such as the default Address table) meets your requirements before building a new one. Reusing standard tables prevents duplicating efforts and ensures better integration with Microsoft apps.
In the Power Apps portal, view the table's properties. Standard tables use default logical names (e.g., 'account'), whereas custom tables use an organization publisher prefix (e.g., 'new_account' or 'cra_account').
If a standard table is close to what you need, you can often customize and extend it by adding new columns, relationships, and views rather than starting from scratch.

Determine the Origin of a Specific Table
Use this method to investigate whether a specific table, like Functional Locations, was created natively by Dynamics 365 or introduced via an installed add-on.
Manage Your Data Exports and Reports with WPS Office
While working with Microsoft Dataverse and Dynamics 365, you frequently need to handle exported data, build reports, and create documentation. WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office, ensuring smooth transitions for all your business tasks.
- 1. Download the installer: Visit the official WPS Office website and click the Free Download button for your operating system.
- 2. Install WPS Office: Run the installer and follow the on-screen instructions to set up the software on your device.
- 3. Open your exported data: Launch WPS Spreadsheets to seamlessly open and analyze the CSV or Excel files exported from Dataverse.

Frequently Asked Questions
Can I convert a custom table into a standard table in Dataverse?
No, once a table is created as a custom table, it permanently retains its custom status and publisher prefix. If you decide a standard table is a better fit later, you will need to migrate your data from the custom table to the standard one.
Why is it better to use standard tables instead of creating custom ones?
Standard tables are deeply integrated into Dynamics 365 applications and often come with built-in business logic, default relationships, and out-of-the-box features. Reusing them prevents data duplication and simplifies long-term maintenance.
Where can I find the logical name of a Dataverse table?
You can find the logical name by navigating to the Power Apps maker portal, clicking on 'Tables' in the left pane, selecting your specific table, and viewing its details under the table properties section.




