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, ... / Access to data in back...
Finance | Project Operations, Human Resources, ...
Unanswered

Access to data in backend tables

(0) ShareShare
ReportReport
Posted on by Trevor Cohen 131

Hi,

As I work more with D365 F&O,  I am seeing that some of the data you require to build reports or whatever live in the backend tables of the database.  

How are you able to access that info, if there is not already a prebuilt export to bring it into excel or the BYOD database?

It seems you need to build a custom export and then have that added to your program.  Is there a guide or process on doing that, or is the another way to link to the backend tables (as read only) to extract data?

Is Data Lakes something that does this? (I have never worked with data lakes before)

Thanks, Trevor

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 299,905 Super User 2025 Season 2 on at
    RE: Access to data in backend tables

    Hi Trevor,

    Indeed, export to Azure Data Lake would be your answer. You can read more about this starting here: learn.microsoft.com/.../azure-data-lake-ga-version-overview

  • Mohit Rampal Profile Picture
    Mohit Rampal 12,563 Moderator on at
    RE: Access to data in backend tables

    Hi Trevor, In addition to Andre's comment, For BYOD, we need to export data from D365 F&O explicitly by adding data entities in a data project in Data Management Workspace. However, in Azure Data lake, export is not required, we need to activate the tables that need to be exported. D365 F&O tables Data will be synced in Data Lake automatically. Currently, there is a limit of 350 tables that can be activated for Azure Data Lake.

    Please check this article to get an overview

    en.dynagile.com/.../practice-5-bi-architecture-how-to-export-data-from-d365-finops-to-azure-datalakea

  • Trevor Cohen Profile Picture
    Trevor Cohen 131 on at
    RE: Access to data in backend tables

    Hi - Do you know f you can have a BYOD database and a Azure Data Lake at the same time.  Or can you only have one or the other?

  • Mohit Rampal Profile Picture
    Mohit Rampal 12,563 Moderator on at
    RE: Access to data in backend tables

    Yes, you can have both BYOD and Azure Data Lake, there is no limitations.

  • Trevor Cohen Profile Picture
    Trevor Cohen 131 on at
    Access to data in backend tables
    Hi,
     
    Does anyone know if Azure data lakes also would have attachments in the export?  Like if you have an invoice attached to a line item, could you also export the attachment?
     
    Thanks,

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

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

#1
André Arnaud de Calavon Profile Picture

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

#2
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 636

#3
Martin Dráb Profile Picture

Martin Dráb 553 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans