Reply
Highlighted
Frequent Visitor
Posts: 2
Registered: ‎11-19-2018
Accepted Solution

How to connect AX2012 with Power BI?

Hi,

 

How to connect ax2012 with power bi for creating the customized reports.


Accepted Solutions
Moderator
Posts: 9,925
Registered: ‎03-10-2016

Re: How to connect AX2012 with Power BI?

@haribaskar,

Do you want to Dynamics AX 2012 in Power BI? If so, based on my research, Dynamics AX 2012 has SQL Server database as backend database, you can use SQL Server connector in Power BI Desktop to connect to the database.

Another method is to use OData Feed connector in Power BI Desktop to connect to Dynamics AX 2012 , for more details, please review this video.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post


All Replies
Moderator
Posts: 9,925
Registered: ‎03-10-2016

Re: How to connect AX2012 with Power BI?

@haribaskar,

Do you want to Dynamics AX 2012 in Power BI? If so, based on my research, Dynamics AX 2012 has SQL Server database as backend database, you can use SQL Server connector in Power BI Desktop to connect to the database.

Another method is to use OData Feed connector in Power BI Desktop to connect to Dynamics AX 2012 , for more details, please review this video.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.