cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
soheil Frequent Visitor
Frequent Visitor

Get Data from Microsoft Dynamics AX

Hi there.

 

Is the any plans to add a service to be able to get data from Dynamics AX 2012 to create analytical reports on Power BI?

If there is any plans for that could you let us know a timeframe please?

 

Thanks

http://www.biinsight.com
4 REPLIES 4
ashishrj Senior Member
Senior Member

Re: Get Data from Microsoft Dynamics AX

If not for 2012, it would be great for AX 2015 or 'Rainier' as it is web based
andre
Advisor

Re: Get Data from Microsoft Dynamics AX

would something like OData work or would volumes be too big?

 

not a Dynamics expert, but I found an article that talks about OData and Dynamics AX, it maybe outdate by now, but maybe it will start you on a course you have not yet considered.

 

http://blogs.msdn.com/b/aif/archive/2011/08/23/odata-query-service.aspx

soheil Frequent Visitor
Frequent Visitor

Re: Get Data from Microsoft Dynamics AX

Thanks for sharing the link.
But, as you stated the volume of data would be too big for OData.
So having a service in Power BI webapp/designer would be the best option.
http://www.biinsight.com
andre
Advisor

Re: Get Data from Microsoft Dynamics AX

I agree but don't forget that there is a 250mb limit in the service right now so you probably wouldn't be able to load too much data at transaction level anyway...