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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Business Central export to datalake

(0) ShareShare
ReportReport
Posted on by 10

Hi all,

In Finance and Operation is it possible to extract data directly to datalake compare the current export in BC to dataverse.
Unlock hidden insights in your Finance and Operations data with data lake integration - Microsoft Dynamics 365 Blog 

Is this function also available in BC or via an extension? or is this a function that will be available in future releases?

Br

Henrik

I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    133 on at

    Can be done via the usage of virtual entities. Check this out: https://youtu.be/mNgx1d7TAXQ

    Speaker did this with the purpose of exporting to data lake for g/l entries

  • Suggested answer
    MahGah Profile Picture
    15,529 on at

    Also you can look into  https://appsource.microsoft.com/en-us/product/dynamics-365-business-central/PUBID.efoqus-5058796%7CAID.replicator%7CPAPPID.18a4d438-88d1-44ee-a38d-3c0ea0d77338 you can replicate your data in database which then can be your source of datalake 

  • Suggested answer
    YUN ZHU Profile Picture
    95,329 Super User 2025 Season 2 on at

    Hi, as far as I know Dataverse can be synchronized to Azure Data Lake. BC can be synchronized to Dataverse ? So maybe it is possible.

    https://docs.microsoft.com/en-us/powerapps/maker/data-platform/azure-synapse-link-data-lake

    https://docs.microsoft.com/en-us/dynamics365/business-central/admin-common-data-service

    Hope this will help.

    Thanks.

    ZHU

  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,105 Moderator on at

    If you still want to export BC data to Azure data lakes you can look at this open source app.

    github.com/.../bc2adls

  • Henrik P Profile Picture
    10 on at

    Hi!

    This sounds really good. Will check it. 

    We are just ready to start the project so it's perfect timing.

    Br 

    Henrik 

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…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,229

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,867 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,153 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans