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 :
Finance | Project Operations, Human Resources, ...
Answered

How to create a data enitity in VS

(0) ShareShare
ReportReport
Posted on by 460

Hi All:

I have created a simply data enitity 'MyDataEntity1' within VS development enviroment (VHD) . But it doesn't appear in Data enitity name lookup list in the data import form. 

Are there any steps I left out ? Could you give some suggestions?

pastedimage1607678851701v1.png

pastedimage1607678923478v2.png

Best Regards

I have the same question (0)
  • Verified answer
    Blue Wang Profile Picture
    on at
  • Verified answer
    nmaenpaa Profile Picture
    101,162 Moderator on at

    Hi Jacky,

    once everything is built and synced, you need to refresh the data entity list via Data management parameters form.

  • Jacky Qian Profile Picture
    460 on at

    Hi Nikolaos, Blue :

    Thanks for your reply.

    Yes, I had done 'refresh the data entity list' as the following illustation, and I had got the refresh success message. Yet, the entity was not visible. 

    I'm going to check my bulit is successful or not.

    pastedimage1607698358563v1.png

    pastedimage1607698371297v2.png

    Best Regards

  • Verified answer
    nmaenpaa Profile Picture
    101,162 Moderator on at

    Hi Jacky,

    a couple of things to consider, once you are sure that you have built your model and synchronized the database.

    - The label of the entity must be unique. If the label text of your entity is the same than some existing entity, then your entity's name will be shown as the label id that you used as the entity label. So there can never be two entries in the Data entities form that would have the same value in "Entity" field (the first field in the grid).

    - You can also try to filter the form by "Target entity" field, using the AOT name of your entity as filtering criteria

    - Please also check that you have set "DataManagementEnabled" property Yes in the entity.

  • Jacky Qian Profile Picture
    460 on at

    Hi Nikolaos, Blue:

    From your comments, I realized that there might be some problems in my build. Therefore, I checked my VS build and really found out  the reason. Now I will report to you.

    Due to my careless mistake, I hadn't  set up 'Synchronize database on bulid' to 'true' in property of my project. I turned it to 'true' and refreshed data entities,then the 'MyDataEntity1'  become be visible now. My problem has been solved, yet could you teach me which database does contain define table of these entities ?

    Thank you.

    pastedimage1607708535216v1.png

     pastedimage1607708975781v2.png

    Best Regards

  • Verified answer
    nmaenpaa Profile Picture
    101,162 Moderator on at

    Hi, the entity is a view and can be found in AxDB database. Also all D365 tables are in that db. 

  • Jacky Qian Profile Picture
    460 on at

    Hi Nikolais:

    OK, I see. Thanks a lot.Then could you teach me AXDW database is what type of DB.

  • Verified answer
    nmaenpaa Profile Picture
    101,162 Moderator on at

    AxDW is Entity Store database and it's used by the aggregate measurements. 

  • Jacky Qian Profile Picture
    460 on at

    Hi Nikolais:

    Thanks for your reply.

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 451 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 428 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans