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

(3) Share

Report

Posted on by davidmcg1299

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

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Martin Dráb 235,792 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.

Was this reply helpful? Yes No