web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Composite data entities
Finance | Project Operations, Human Resources, ...
Answered

Composite data entities

(1) ShareShare
ReportReport
Posted on by DP-04060556-0 103
Hi experts,
Recently I has an issue whereby users can not use "Open in excel" for composites data entities for users hold "Data migration admin" role. They can access Composites data entities from Data management workspace but cannot see those entities from "Open in excel" menu. please advise.
 
Daniel
I have the same question (0)
  • DP-04060556-0 Profile Picture
    DP-04060556-0 103 on at
    Composite data entities
     
    yes, you are right. thanks for your advise.
     
    Daniel
  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 236,045 Most Valuable Professional on at
    Composite data entities
    Note that this thread isn't about composite data entities at all.
     
    Composite entities aren't exposed via OData, and because Open in Excel uses OData, they can't be used there either. They're supported in data management only.
     
    Both InventInventoryMovementJournalEntryV4Entity and InventInventoryAdjustmentJournalEntryV2Entity are normal data entities, not composite ones.
     
    Access to InventInventoryAdjustmentJournalEntryV2Entity is granted by two privileges: InventInventoryAdjustmentJournalEntryEntityExport and InventInventoryAdjustmentJournalEntryEntityImport. But it won't work even if you assign them to users, because they have Integration Mode = Data Management, therefore they don't give permissions to OData. You'll have to create new privileges.
  • DP-04060556-0 Profile Picture
    DP-04060556-0 103 on at
    Composite data entities
    Hi Layan Jwei,
    the data entity that users cannot see is Inventory adjustment journal headers and lines V2, however user can see Inventory movement journal headers and lines V4 from "Open in excel". it is a standard items and I did not create new privilege for it. I had try to assigned "Data migration administrator" , "IT manager" to users but unsuccessful.
     
    Daniel
  • Layan Jwei Profile Picture
    Layan Jwei 8,027 Super User 2025 Season 2 on at
    Composite data entities
    Hi,
     
    What are the composite entities that you can't see? Are they standard or custom? And if they are custom, did you create privileges for them and assigned them to the data migration role? If not, then make sure the role has access to those entities
     
    Also can you see them using a different role?
     
     

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 895

#2
Sohaib Cheema Profile Picture

Sohaib Cheema 811 User Group Leader

#3
André Arnaud de Calavon Profile Picture

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

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans