Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This article is a collection of frequently asked questions about Business Central virtual tables.
Can a solution from an independent software vendor (ISV) take a dependency on virtual tables? What does the application lifecycle management (ALM) look like?
Yes. The virtual tables are all generated in the MicrosoftBusinessCentralERPVE solution, which is API-managed. In other words, the items in the solution change as you make tables visible or hidden, but the solution is still a managed solution that you can take dependency on. The standard ALM flow just takes a standard reference to a virtual table from this solution with the Add existing option in the ISV solution. Missing dependency of the solution is checked when the solution is imported and during import, if a specified virtual table doesn't yet exist, the virtual table is automatically made visible.
Which tables from Business Central do users see in the catalog in Microsoft Dataverse?
Generally, users can see all tables exposed as API (v.2.0) and data exposed via custom APIs. Remember that you need to make them visible before they appear in the Table view.
Do all Microsoft Power Platform users have to be users in Business Central?
Any user of Microsoft Power Platform who tries to access Business Central data through a virtual table must also exist as a user in Business Central. Therefore, technically, not all users have to be users in Business Central. Only those users who access Business Central data through virtual tables must be users in Business Central.
Where do I find available tables to be exposed inside Dataverse?
In the Table view, the table is named Available Business Central tables. You can also run our preinstalled app called Business Central Configuration.
Can I change the prefix for the virtual tables?
No. All Business Central virtual tables should be generated in the MicrosoftBusinessCentralERPVE solution, and they all have the "dyn365bc_" prefix. This prefix can't be changed.
How can I show, in the same grid, data from multiple virtual tables that are joined to a physical table record in Dataverse?
This approach isn't currently possible in Dataverse.
If I want a default value to be entered in a column during precreate, will an initValue on the data table then work?
Yes. Here's the order of calls:
- Dataverse sends a create or update message.
- All the existing logic on the Business Central table and backing tables is invoked. This logic includes default value entry that might change values.
- Dataverse sends another Retrieve (single) message to get the latest copy of the data, including any columns that default values were entered for.
How do I verify the version of your Business Central Virtual Table Plugin?
Depending on the region, the Business Central Virtual Table Plugin version might vary. To verify your version, you need to:
Sign in to Power Platform admin center.
Open the environment you use, locate Resources, and select Dynamics 365 apps.
Locate the Business Central Virtual Entity app in the list, and then select ... (More application actions) > Details.
In the Business Central Virtual Entity Details pane, the Version column under Package(s) displays the current version number.
Related information
Overview - Integrating Business Central with Microsoft Dataverse
Microsoft Power Platform Integration with Business Central
Table Modeling
Business Central and Microsoft Dataverse Admin Reference
Application Lifecycle Management for Solutions that use Virtual tables