web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Directly Export data e...

Finance | Project Operations, Human Resources, ...

Answered

Directly Export data entities to Data Lake instead of underlying tables

(0) Share

Report

Report

Posted on by MYGz

2,355

Hi,

With Export to Data Lake feature we can export only tables to Data Lake.

How to Export the Data Entity as it is to Data Lake to use it for Analytics with Power BI.

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

André Arnaud de Cal... 304,596 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi MYGz,

With the Synapse or Fabric link, there are a few data entities available, which can be found in the Dataverse view, starting with 'mserp'.

It is recommended to export the underlying F&O tables and create views in the Data Lake or OneLake, similar to the data entities in Dynamics 365 F&O, to ensure all data is synchronized based on the actual table triggers. The data entities do not all have reliable views to ensure all changes are recognized when they appear in F&O.

Was this reply helpful? Yes No
MYGz 2,355 on at

Like (0)

Report
Copy link

Link copied!

Thank You @André Arnaud de Calavon

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

Giorgio Bonacorsi 635

#2

André Arnaud de Cal... 592 Super User 2026 Season 1

#3

CP04-islander 356

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans