You can use a Virtual Table.
A virtual table lets Dataverse display data from an external system, such as a SQL database, without storing a copy of that data in Dataverse.
The data remains in the external SQL database. When needed, Dataverse accesses it through the configured connection or data provider.
For example, if customer data already exists in an external SQL database, you can expose it in Dataverse using a virtual table instead of importing and duplicating all the customer records.
Interview tip: You might be asked, “Why not use a regular table and sync the SQL data with a flow?” Because syncing creates a copy of the data in Dataverse, and the data may not always be up to date because it depends on the sync frequency. Virtual Tables avoid both problems—the data stays in the external system and is accessed without copying it into Dataverse.
