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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / D365 Financial Reporti...
Finance | Project Operations, Human Resources, ...
Suggested Answer

D365 Financial Reporting Data Mart Access

(3) ShareShare
ReportReport
Posted on by sswiney 11

Other than through the temporary access via LCS Environment Database Accounts, are there any other options for accessing the D365 Financial Reporting Data Mart tables? 

I have the same question (1)
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

    Hi sswiney,

    No, there is no other access apart from creating the financial reports and the temporary access.

  • AO-09090006-0 Profile Picture
    AO-09090006-0 14 on at
    @André Arnaud de Calavon do you know if 3 years later this is still the case? We have Financial Reporting enabled in our F&O environment however would like to connect to it via other technologies in the stack such as Azure Synapse Analytics and/or Power BI outside of logging in to F&O and using the native experience.
  • Suggested answer
    Navneeth Nagrajan Profile Picture
    Navneeth Nagrajan 2,438 Super User 2025 Season 2 on at
    Hi Sswiney,
     
    Check out this reference documentation. As highlighted by Andre, there are no other options to access the D365 financial reporting data mart tables.
     
    There is a section on "Reset the financial reporting data mart for Dynamics 365 Finance + Operations".
     
     
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at
    Hi AO-09090006-0,

    As mentioned by Navneeth, there was no change in accessing the data mart database. There were changes in how data will be exposed to other services like Synapse or Fabric. Instead of trying to get the data mart data, you can sync accounting entries and other master data and transactions using the Synapse or Fabric link. The financial reporter data mart is also a sync of transactions from Dynamics 365 Finance.
  • AO-09090006-0 Profile Picture
    AO-09090006-0 14 on at
    Thanks @André Arnaud de Calavon and @Navneeth Nagrajan for that insight. 
     
    The challenge for me is I am trying to replicate datamart tables from base tables exported via Azure Synapse Link, however I haven't got access to the underlying view definitions or stored procedures that build those final tables. For example, I am trying to recreate DimensionCombination, DimensionPeroidBalance, DimensionValue, Fact, FiscalCalendarView, Organization, Scenario. Do you know where such definitions and documentation can be found?
     
    Many thanks
  • AO-09090006-0 Profile Picture
    AO-09090006-0 14 on at
     
    I've submitted an idea here Microsoft Idea "D365 Financial Reporting Data Mart Access" and would appreciate your votes.
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at
    Hi sswiney,

    The data model of both Dynamics 365 F&O and the Financial Reporter databases is hard to understand. I don't know by head what exact tables to combine. That requires a thorough investigation. For AX 2012 R2, there was a data model description and some ERD diagrams. This was not updated by Microsoft anymore, and the data model has changed in the meantime. You can view the old ERD diagrams on a site hosted by Alex Meyer. AxErd Home. Note that the dimension storage depends on a feature that can be enabled in the application. See also: New financial dimension sets - Finance | Dynamics 365 | Microsoft Learn
     
    My recommendation remains to take the Dynamics 365 F&O tables as a base. Unfortunately, I don't have documentation about the full data model.

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

Quick Links

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 551 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 450 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 278 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans