Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

AX2012 R3 and Power BI

Posted on by Microsoft Employee

This is more of a general question. We are in the early stages of using Power BI and are looking for any resources on what tables in AX2012 (more specifically what fields within those tables) to use to create various sales reports and dashboards. We are on AX2012 R3.

Categories:
  • Suggested answer
    ColbyGallagher Profile Picture
    ColbyGallagher 3,664 on at
    RE: AX2012 R3 and Power BI

    Hi Benjamin, 

      Look at the "perspectives" node in the AOT, that will show you all the out of the box views that are used to feed the SSAS Cubes, which you can leverage in PowerBI.

    For Sales reports, look at the view CustInvoiceTransExpanded, you'll find that has most the raw data elements you want. 

    pastedimage1654775698554v1.png

    If you go look at that in the View node, you'll see its fed by query CustInvoiceTransExpanded which has CustInvoiceTrans joined to several other tables:

    pastedimage1654775896151v3.png

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans