Skip to main content
Post a question

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id : GYsFNx9/S4ebWzfuEcEOQY
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

Like (0) ShareShare
ReportReport
Posted on 26 May 2023 17:42:31 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

  • Trevor Cohen Profile Picture
    Trevor Cohen 131 on 21 Jun 2023 at 17:47:21
    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,
  • Mohit Rampal Profile Picture
    Mohit Rampal 12,556 Moderator on 03 Jun 2023 at 00:11:44
    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 02 Jun 2023 at 18:25:59
    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,556 Moderator on 27 May 2023 at 05:25:34
    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

  • AndrĂ© Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,884 Super User 2025 Season 1 on 26 May 2023 at 22:09:34
    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

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,884 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,760 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans