web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / D365 Real Time Journey...
Customer experience | Sales, Customer Insights,...
Answered

D365 Real Time Journeys reporting & Microsoft Fabric

(3) ShareShare
ReportReport
Posted on by ralucad 56
Hi
 
Is our only option now to use Microsoft Fabric if we want to report on the customer interaction data from Real Time Journeys?
The price is so high, and its not really worth paying it if we are not going to use it for anything else.
 
Are there any other options? 
 
Thank you
 
 
Categories:
Dynamics 365 Customer Insights - Journeys
I have the same question (0)
  • Gus Profile Picture
    Gus 218 on at
    D365 Real Time Journeys reporting & Microsoft Fabric
    Hi. @ralucad.  Some data like form submissions for CIJ are in dataverse but the interactions data, e.g. form visits, web visits are not so Fabric is only soltuion for virtual tables.  I also found that the Fabric connection is not quite complete, there is basic data that is missing you have to work around.  I would say this is a work in progress at best but is currently only solution if you want access to virtual tables like web visits, email clicks, etc.   Just be cautious that data like business unit, etc are not there and require setting up connections.  
  • MikeC282 Profile Picture
    MikeC282 2,171 on at
    D365 Real Time Journeys reporting & Microsoft Fabric
    I'm sorry as I'll just call it out as it is. Holly's answers are all very much wrong so I don't understand who verified it as answered as it needs to be revoked.
     
    1. You can't connect BI reports to the interaction data from Journeys cause it's stored in a datalake not in the dataverse. Thank goodness it is as well. Can you imagine all that data being stored in the dataverse? You'd run out of storage capacity very quickly.
    2. If you're referring to accessing the datalake where the interaction data is stored then those methods have all seemed to be patched up. Microsoft seems intent on pushing people to use the very expensive Fabric Capacity licenses.
    3, 4 and 5 are all basically saying the same thing except there's not method to access the underlying data stored in that datalake unless someone can point in the right direction?
     
    I'm sorry these answers read like hallucinations generated from AI as I've been searching for a way to get around Fabric on Google and getting very similar answers which are all wrong.
  • ralucad Profile Picture
    ralucad 56 on at
    D365 Real Time Journeys reporting & Microsoft Fabric
    Thank you both, I actually find jwcpc's answer a bit more practical, but Holly you provided a lot of alternatives and some pros and cons which I also find helpful :)
  • Verified answer
    jwcpc Profile Picture
    jwcpc 272 on at
    D365 Real Time Journeys reporting & Microsoft Fabric
    I'm not sure that's correct, Holly. But feel free to show me steps to connect to real time interaction via Dataverse, I have never found the tables in there. Outbound marketing is all in Blob storage. There is this currently in Public Preview: https://learn.microsoft.com/en-us/dynamics365/release-plan/2025wave1/customer-insights/dynamics365-customer-insights-journeys/export-data-own-storage-custom-reporting
  • Verified answer
    Holly Huffman Profile Picture
    Holly Huffman 6,522 Super User 2025 Season 2 on at
    D365 Real Time Journeys reporting & Microsoft Fabric
    Good morning, afternoon, or evening depending on your location!
    Hope you are well today :)
     
    While Microsoft Fabric offers seamless integration with D365 Real Time Journeys, its cost may not be justified if they’re not leveraging its full capabilities. Fortunately, there are alternative ways to report on customer interaction data without relying solely on Fabric.
    Alternative Reporting Options for D365 Real Time Journeys
    1. Dataverse Direct Queries in Power BI
      • Since Real Time Journeys stores data in Dataverse, your client can connect Power BI directly to Dataverse using the OData feed or the Dataverse connector.
      • This allows them to build reports without needing Fabric.
    2. Export Data to Azure Storage
      • If they have Azure Blob Storage, they can export Real Time Journeys data to a storage account and connect Power BI to it.
      • This method is useful for organizations that already use Azure but don’t want to pay for Fabric.
    3. Use Power Automate for Data Extraction
      • Power Automate can be used to extract customer interaction data from D365 Real Time Journeys and store it in SharePoint, SQL, or another accessible database.
      • Power BI can then connect to these sources for reporting.
    4. Custom API Integration
      • If they have development resources, they can use Dynamics 365 APIs to pull Real Time Journeys data into a custom reporting database.
      • This requires some technical setup but avoids Fabric costs.
    5. Third-Party ETL Tools
      • Some organizations use third-party ETL tools like Azure Data Factory or Talend to extract and transform data from D365 Real Time Journeys into a more cost-effective reporting solution.
    Key Considerations
    • Data Refresh Rates: Fabric provides real-time updates, whereas alternatives may require scheduled refreshes.
    • Complexity vs. Cost: Some alternatives require more setup but can significantly reduce costs.
    • Security & Compliance: Ensure that any alternative method aligns with data governance policies.
    If you are seeking a low-cost solution, Dataverse direct queries in Power BI or Azure Blob Storage exports might be the best options.
     
     
    Hope this is helpful :)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 258

#2
MVP-Daniyal Khaleel Profile Picture

MVP-Daniyal Khaleel 172

#3
Tom_Gioielli Profile Picture

Tom_Gioielli 116 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans