Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
constantLearner
Frequent Visitor

Connect Microsoft Dynamics AX 2012 R3 with PowerBI

Hi All,

 

Can someone let me know how to connect PowerBI with Microsoft Dynamics AX 2012 R3?

 

Since Dynamics AX 2012 has SQL Server at the backend will SQL replication work to create custom reports?

 

Does this mean that there will no out of box reports when connecting Microsoft Dynamics AX 2012 R3 with PowerBI?

 

Regards.

2 ACCEPTED SOLUTIONS

@constantLearner Looks like Dynamics AX 7 is the only one supported in the Content Pack. I'm not an AX guy, but from a quick check, it looks like you can create a seperate Entity Store (SQL Server) for reporting purposes. Then you can use Power BI to connect to that.

 


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

v-qiuyu-msft
Community Support
Community Support

Hi @constantLearner,

 

I agree with @Seth_C_Bauer that available Dynamics CRM content pack requires Dynamics AX 7 environment currently. In your scenario, please use OData data source type in Power BI Desktop to retrieve data from Dynamic AX 2012 R3. For more information, please refer to links below:

Create a Power BI report by using Microsoft Dynamics AX data

Microsoft Dynamics AX 2012 R3 integration with Power BI for Office 365

 

Regarding the question about whether backend SQL Server will generate cutom reports, I would suggest you post a thread in Microsoft Dynamics AX 2012: Reporting and BI forum.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
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

5 REPLIES 5
v-qiuyu-msft
Community Support
Community Support

Hi @constantLearner,

 

I agree with @Seth_C_Bauer that available Dynamics CRM content pack requires Dynamics AX 7 environment currently. In your scenario, please use OData data source type in Power BI Desktop to retrieve data from Dynamic AX 2012 R3. For more information, please refer to links below:

Create a Power BI report by using Microsoft Dynamics AX data

Microsoft Dynamics AX 2012 R3 integration with Power BI for Office 365

 

Regarding the question about whether backend SQL Server will generate cutom reports, I would suggest you post a thread in Microsoft Dynamics AX 2012: Reporting and BI forum.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hi,

 

You can certainly connect to the back-end SQL database and create reports in Power BI. Obviously, you would connect in a Development/Test environment. It wouldn't be too ideal in a production environment, as you can imagine. The entity store update was released for R3, which allows you to connect to them and report from them. The entity store is simply a separate database of entities (views) that are optimized for DirectQuery and reporting with Power BI.

 

AX 2012 R3 also supports OData feed, which enforces AX security inherently. However, it is quite a bit slower when handling larger data sets. You can also connect to the AX cubes using SSAS.

 

There are no content packs that I am aware of (out of the box).

 

 

Cheers,

Mark

Hi @Anonymous,

 

 Connecting AX 7 (Dev/Test) with power BI using SQL server connection works fine. But is it possible to connect Production server with it? Not sure if proper privileges are provided by Micorosft on the production server to use the SQL server credentials to connecto to Power BI desktop.

 

 

 

Please see my latest blog post to see how to connect AX 2012 R3 Data Feed to Power BI

 

http://immerhier.com/connect-microsoft-power-bi-to-ax-2012-odata-query-service/

@constantLearner Looks like Dynamics AX 7 is the only one supported in the Content Pack. I'm not an AX guy, but from a quick check, it looks like you can create a seperate Entity Store (SQL Server) for reporting purposes. Then you can use Power BI to connect to that.

 


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

Helpful resources

Announcements
March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors