Forum Discussion

KARE's avatar
KARE
New Member
9 years ago

PowerBI and Dynamics AX Integration - filter by data record selection in Dynamics AX

Hi,

 

all examples concerning the integration of PowerBI  in Dynamics AX show as starting point only totals! So if I would start in a workspace for customer- the PowerBI report show e.g. the turnover, number of order as total for all customers... and then you can drill-down in the PowerBI report to a specific customer.

 

So may question is, would it also be  possible to select a data record in Dynamics AX and the PowerBI report will only show the values for this selected data record. e.g. I select a customer in Dynamics AX and only the turnover, number of orders, open invoices for this customer is shown in the PowerBI report?

 

Thanks

Rene

 

 

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi KARE,

    Based on my research, Power BI Service retrieves data of Dynamics AX 7 based on the Dynamics AX 7 environment URL, there is no place that we can put parameter to get only filtered data for specific customer at the beginning of importing Microsoft Dynamics AX content pack.

    As a workaround for this issue, you can consider to connect to Dynamics AX via OData Feed entry in Power BI Desktop, filter rows and model your data in Desktop, then create reports and publish the Desktop file to Power BI service.


    Alternatively, you can connect to Dynamics AX via OData Feed entry in Excel, model your data, then create reports and upload the worksheet to Power BI service, for more details, please review this blog.


    Thanks,
    Lydia Zhang

    • KARE's avatar
      KARE
      New Member
      9 years ago

      Hello Lydia,

       

      thanks for you answer. So you don't see the possibility to interact with PowerBI embedded in a Dynamics AX workspace directly by selecting a data-record?

       

       

      Thanks

      Rene

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi KARE,

        Yes. Within the content pack, we have less control. Please use Power BI Desktop to connect to Dynamics AX  and filter data based on  your needs.

        Thanks,
        Lydia Zhang