Latest Enterprise DNA Initiatives

Microsoft AX - Automatic Report and Consolidation in AX

Dear DNA Team,

I might be a bit off the topic but I will appreciate any responses from the experts.

I would like to know “how” and what kind of module/license do I need to have in order to link AX to Excel.

My goal is to link AX to Excel templates so I could automatically generate and refresh daily reports.

Also, did anyone has experience building consolidation in the AX?

Any help will be appreciated.

Thank you


Bumping this post for more visibility.

1 Like

Hi @Matty - This is primarily a Power BI related Forum. Don’t think many will be able to help here and also it’s been 6 days since you started the post.

Suggest to raise it at AX Support level if it is available Online and close this Ticket.

Ankit J

1 Like

Hi @Matty, did the response provided by @ankit help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!

Hi @Matty, we’ve noticed that no response has been received from you since July 27. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

Hi @Matty, due to inactivity, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.