D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

D365 Table name help

  • 1.  D365 Table name help

    SILVER CONTRIBUTOR
    Posted Jul 26, 2021 03:00 PM
    Hi everyone.  We just upgraded from Dynamics AX 2012 R2 to D365 recently.  I use Microsoft Power BI Designer to build dashboard reports.  I'm having difficulty finding this AX table in D365.  Anyone know what it's called in D365?  I've been looking for it in the Data Entities list but can't find it.  Please note I'm an Accountant and not an IT person.  I only play an IT person on TV, haha:).  In the past year, learning Power BI I've learned enough about the AX database to find tables I needed to build datasets for reports but that's about all I know.  Here's the information about the AX table I'm looking for in D365.  Also if anyone has any resources that help with how tables relate to one another that would help me with building datasets from D365 that would be be most appreciated!

    Table ID

    System name

    Table name

    385

    DimensionAttributeValueCombination

    Dimension code combination



    ------------------------------
    Brad Reeves
    Manager - Finance
    Bill And Hillary Clinton National Airport
    Little Rock AR
    ------------------------------


  • 2.  RE: D365 Table name help

    SILVER CONTRIBUTOR
    Posted Jul 27, 2021 09:23 AM

    Hi Brad,

     

    The DimensionAttributeValueCombination table does exist in D365.  However, not every table in the database has an entity associated with it.  Depending on the bigger picture of what you're after, you may find what you need in another entity.  If not, you can always create an entity that will extract that table and be available via data management in the same way.  If you're not comfortable using Visual Studio or the D365 developer tools, you may need to involve IT to get this done.   

     

    Please let me know if I may provide additional information. 

     

    Best,

    Ben

     

    BENMORGAN

    520.293.1488 ext. 7472

     

     






If you've found this thread useful, dive deeper into User Group community content by role