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, ... Export to Data Lake En...

Finance | Project Operations, Human Resources, ...

Unanswered

Export to Data Lake Entity defines all fields but misses fields within the SQL Create View statements

(0) Share

Report

Report

Posted on by Rc86

5

Hi,

We have Export to data lake enabled in our F&O instance. It was successfully working for a number of defined entities but we are now seeing that for a single entity it has dropped a field from the autogenerated SQL create statement present in the JSON file under the ChangeFeed within the lake. As such when the CSV files are re-inflated into the SQL instance the view representing the entity is incomplete and we not have downstream reports failing.

The field is still defined within this JSON and present within the CSV's exported. Anyone got any ideas what is going on?

I have the same question (0)

All responses Img

All responses (0)

Answers Img

Answers (0)

Join the conversation

Helpful resources

Quick Links

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

#1

Giorgio Bonacorsi 658

#2

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

#3

Syed Haris Shah 333 Super User 2026 Season 1

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