'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Access Dynamics 365 Real-Time Journey Data in Fabric Lakehouse
Question details
The user needs to identify specific tables containing Dynamics 365 Customer Insights Real-Time Journey data and understand how to integrate this data into a Microsoft Fabric Lakehouse.
- Product
- Dynamics 365 Customer Insights / Microsoft Fabric
- Device & OS
- not provided
- Scenario
- Integrating CRM marketing data into a centralized data lakehouse for unified analytics and reporting.
- Observed behavior
- The user is seeking structural guidance on locating the correct data tables and establishing a pipeline or link to Microsoft Fabric.
Verify that you have System Administrator permissions in your Dynamics 365 Customer Insights environment and sufficient workspace privileges in Microsoft Fabric before attempting data integration.
Consult the Microsoft Dynamics Community Forum
Because Real-Time Journey data architectures can vary based on your specific environment and version, consulting specialized Microsoft experts is the most reliable approach.
Real-Time Journey data tables in Dynamics 365 are often stored in Dataverse, but their exact schemas can change. The Dynamics Community forum is actively monitored by Microsoft specialists who can provide the most current documentation and guidance tailored to your specific setup.
Document your Dynamics 365 Customer Insights environment version, your current data sources, and the specific Fabric architecture you are trying to implement.
Go to the official Microsoft Dynamics Community forums (community.dynamics.com) and navigate to the Customer Insights section.
Create a new thread asking for the exact Dataverse table names for Real-Time Journeys and the recommended method for linking them to Fabric Lakehouse.
Use Microsoft Dataverse Link to Fabric
For most modern Dynamics 365 deployments, data is stored in Dataverse, which offers a direct native link to Microsoft Fabric.
Analyze Exported Dynamics 365 Data Locally with WPS Office
If you need to export your Dynamics 365 Customer Insights data or Fabric Lakehouse query results for local analysis, WPS Office provides a powerful, free alternative to Microsoft Office. It easily handles large spreadsheets and CSV files while offering a familiar, lightweight experience.
- 1. Export your data: Export your Real-Time Journey reports from Dynamics 365 or Microsoft Fabric as a CSV or Excel file.
- 2. Open in WPS Spreadsheet: Launch WPS Office and open your downloaded spreadsheet to instantly view your data.
- 3. Analyze and visualize: Use familiar tools like PivotTables, charts, and custom formulas in WPS Spreadsheet to analyze your customer journey metrics.
Frequently Asked Questions
Where is Dynamics 365 Real-Time Journey data actually stored?
Dynamics 365 Customer Insights Real-Time Journey data is primarily stored within Microsoft Dataverse. The specific underlying tables usually have prefixes like 'msdyncrm_' depending on the exact module and version you are using.
Can I directly query Dataverse from Microsoft Fabric?
Yes. Microsoft Fabric supports native integration with Dataverse. By utilizing the 'Link to Microsoft Fabric' feature in the Power Apps portal, you can create direct shortcuts in your Fabric Lakehouse to query Dataverse tables using SQL without copying the data.
Why are some Dynamics 365 tables missing in my Fabric Lakehouse?
If tables are missing, they may not have been explicitly selected when configuring the Dataverse Link, or they may lack the 'Track changes' property in Dataverse, which is required for synchronization to Synapse or Fabric.
