topic Re: Get Data from Microsoft Dynamics AX in Power Query

Get Data from Microsoft Dynamics AX

Anonymous — Sun, 12 Jul 2015 21:16:44 GMT

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

Re: Get Data from Microsoft Dynamics AX

ashishrj — Mon, 13 Jul 2015 04:09:37 GMT

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

Re: Get Data from Microsoft Dynamics AX

andre — Mon, 13 Jul 2015 16:25:38 GMT

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

Re: Get Data from Microsoft Dynamics AX

Anonymous — Tue, 14 Jul 2015 00:07:28 GMT

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.

Re: Get Data from Microsoft Dynamics AX

andre — Tue, 14 Jul 2015 01:37:38 GMT

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...