Forum Discussion

pbapuji's avatar
pbapuji
Helper I
8 years ago

Direct connection for Microsoft dynamics AX

Hi All,   Does power bi supports direct connction for microsoft dynamics AX? if not, How we can handle it for huge data extraction?   Thanks!
Need Help
pbapuji's avatar
pbapuji
Helper I
8 years ago

@v-chuncz-msft 

 

I got to know that the direct query not supported for  Microsoft AX dynamics.

 

So any idea how we can handle it for large data extaction from Microsoft AX dynamics?

 

 Is there is any possibility from Source side(Microsoft AX dynamics)?

 

Thanks

Phillip's avatar
Phillip
Regular Visitor
8 years ago

Hi,

 

Yes. DirectQuery is supported by Dynamics AX. What version of Dynamics AX are you referring to? Is it Dynamics for Operations (formerly AX)?

 

In order to DirectQuery the AX Datawarehouse, you must have administrator access to the project in AX and LifeCycle services. Once you have the correct permissions, you can deploy your Power BI file to the Power BI service. 

 

Let me know about my former question, and we can discuss more in depth the process you follow as I architect enterprise deployments for Dynamics products including Dynamics 365. 

 

Looking forward to hearing from you. 

  • pbapuji's avatar
    pbapuji
    Helper I
    8 years ago

    Phillip

     

    I am referring microsoft dynamics AX 2012 R3 on primises, Is this supports direct query connction?

     

    Sorry for the delay.

     

    Thanks,