Create a New Read-Only Table in Dataverse with External Data Storage

New Read-Only Table in Dataverse with External Data Storage


You create a new read-only table in the Dataverse database that has external data storage.

What is the type of this table?



Click on the arrows to vote for the correct answer

A. B. C. D. E.

Correct Answer: D

Dataverse provides the three types of tables (entities): Standard - this is a usual custom table type that users can create.

These tables store data and navigation for model-driven apps.

Activity - this is a special custom table type for storing activity information like appointments, phone calls, emails, tasks, etc.

Virtual - this custom table type has columns that bring data from external sources, like Azure SQL Database or Azure Cosmos DB.

Virtual tables have a list of limitations.

There are two most important limitations: data in these tables are read-only, and users cannot create or update records.

You need to use a classic interface for the creation of the virtual table.

From the Power Apps portal, you can access Advanced settings, and then on the Administration screen, select Virtual Entity Data Sources.

There you can create a new data source you would use for the virtual table creation (Number 2)

Then from the Solutions/Default Solutions on the Power Apps portal screen, you can select the “Switch to classic” option.

Portal will open the Dynamics 365 Default Solution screen.

In the menu tree, you choose Entities and push the New button on the tab toolbar.

You need to provide a name for the new table, check the Virtual Entity box (Number 1), and select a Data Source (Number 2).

El save @ Save&Close + New WD Flow v

New PC Manufactures


PC Model Name a

——- x 2)

< Change View
*f& Teams


User Lookup View (default)
Activity Sender Users Lookup View
Salespeople Lookup View

Unassigned Salespeople

} Only my records

It is important to remember that you cannot change the table type after table creation.

All other options are incorrect.

For more information about Dataverse table types, please visit the below URLs:

Sure, I'd be happy to help!

When you create a new table in Dataverse, you have the option to choose between several different types of tables. In this case, you have created a new table that has external data storage and is read-only. Based on this information, we can eliminate a few of the answer choices right off the bat:

  • System tables are created and managed by Dataverse itself, and cannot be modified by users. You wouldn't be able to create a new read-only table of this type.
  • Activity tables are used to track activity data, such as the creation or modification of records. Again, this doesn't seem to fit with the scenario you've described.

So we're left with three possible answer choices: Standard, Relational, and Virtual. Let's take a closer look at each of these.

  • Standard tables are the most common type of table in Dataverse. They store data in a flat structure, with each record having its own set of fields. Standard tables can be used to store a wide variety of data types, including text, numbers, dates, and more. They can also be linked to other tables using relationships.
  • Relational tables are similar to standard tables, but they are designed specifically for storing data that is related to other tables. They use primary and foreign keys to establish relationships between tables. Relational tables are often used when you need to store large amounts of data in a structured and organized way.
  • Virtual tables are a bit different from the other two types. They don't actually store any data themselves; instead, they act as a way to combine data from multiple sources into a single view. Virtual tables can be used to create reports or dashboards that show data from across your Dataverse environment.

So, which of these three types is most likely to be the type of table you've created? Based on the fact that you've mentioned external data storage, it seems likely that you're using a virtual table. Virtual tables are often used when you need to combine data from multiple sources, and they can be set up to be read-only if you don't want users to be able to modify the underlying data.

Therefore, the answer to your question is likely D. Virtual.