News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Extended Data Types fi...

Finance | Project Operations, Human Resources, ...

Answered

Extended Data Types fields where in the database for BI? - smmactivities.usermemo

(1) Share

Report

Report

Posted on by davidmcg1299

7

Hi all,

I am looking to find this field for BI purposes: smmactivities.usermemo.

I am currently using the Export to Datalake on D365FO and this field is not in the version of the table smmactivities that I can see.

I have come across this before with Extended Datatypes. It seems they are not actually part of the core table but SSMS does see them as part of the table. Any ideas how/if I can reach this data for BI purposes?

Any help/advice greatly appreciated.

David

Categories:

Dynamics 365 Finance

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Martin Dráb 230,551 Most Valuable Professional on at

Like (2)

Report

Extended Data Types fields where in the database for BI? - smmactivities.usermemo

That's by design - fields with String Size = (Memo) are one type of fields that aren't supported by Export to Data Lake. You can find this information in documentation.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,462 Super User 2024 Season 2

#2

Martin Dráb 230,551 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans