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 / Finance | Project Operations, Human Resources, ... / How do I find out what...
Finance | Project Operations, Human Resources, ...
Answered

How do I find out what underlying tables a report is using?

(0) ShareShare
ReportReport
Posted on by VickyD

We have a whole host of reports available in our D365 Finance & Operations instance. I am looking to connect to D365 from Power BI using Odata connector and pull the relevant data for say a report and build Power BI reports based on it. 

I'm having a hard time determining what are the source tables/entities that the report is using. Is there an easy and foolproof way to identify the table that I can then import into Power BI? 

My google searches have only provided vague answers but I'm hoping there is a proper way to get the table information. Almost feel like there is a model/cube sitting in between the reports and the underlying tables/entities but I may be wrong. 

Note: The reports I'm referring to have been built using "Financial Reporting Designer". 

I have the same question (0)
  • VickyD Profile Picture
    VickyD on at
    RE: How do I find out what underlying tables a report is using?

    Thanks so much for these links. I guess I was just searching for the wrong this. This option definitely seems way more promising!

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 297,572 Super User 2025 Season 2 on at
    RE: How do I find out what underlying tables a report is using?

    Hi Vicky,

    You shared a community blog. For sure it is possible to connect via OData, but that would take ages as it is not the best performing tool. You can read the Microsoft documentation for the recommended way of exporting data to Data Lake or BYOD.

    Bring your own database (BYOD) - Finance & Operations | Dynamics 365 | Microsoft Learn

    Export to Azure Data Lake overview - Finance & Operations | Dynamics 365 | Microsoft Learn

  • VickyD Profile Picture
    VickyD on at
    RE: How do I find out what underlying tables a report is using?

    Thanks Andre for the quick response.

    I'm actually tasked with building a centralized data model that will help with reporting across financials, sales, operations from different sources so we do need to bring the financial data into Power BI Service using dataflows in power bi (technically azure data lake) and then build datasets (technically AS models) which will then be used for reporting.

    I thought odata connection as described here is the primary way to make that happen. Is there another/better way?

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 297,572 Super User 2025 Season 2 on at
    RE: How do I find out what underlying tables a report is using?

    Hi Vicky,

    The financial reports are using a separate datamart database part of Management Reporter. The accounting entries are synced to this database. There is no public access to this datamart database.

    It is not recommended to use OData for querying financial transactions. Instead, look at the options to export transactions to BYOD or Azure Data Lake. These would be performing better as input for Power BI.

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

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

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

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 823 User Group Leader

#2
André Arnaud de Calavon Profile Picture

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

#3
Martin Dráb Profile Picture

Martin Dráb 491 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans