Views:

Applies to Product - Dynamics 365 Finance


What’s happening?
The customer is unable to see CRM entities in Dataverse, only core tables are visible.
 

Reason:
This arises because entities that are views require "SQL row version change tracking" to be enabled before they can be exposed for export via the PowerApps portal. Additionally, entities without a ReportViewName will not be displayed in SQL Server Management Studio (SSMS) or Power BI by design.
 

Resolution:

  1. Ensure that the entities have a ReportViewName. Entities without this will not be displayed in SSMS or Power BI.
  2. Check if the "SQL row version change tracking" is enabled for the entity views. If it is not supported, the process may fail within the CRM interface.
  3. If the EnableDisplayNames parameter is set to true in Power BI, set it to false in the advanced editor to disable the display name feature.
  4. Ensure you are using the latest version of Power BI Desktop and connect to the TDS endpoint from the corporate network, not from a VPN.
  5. Review the prerequisites mentioned in the documentation for using finance and operations data in Azure Synapse for Dataverse.