I'd like to know is there any way to connect between AX and Power BI.
If so, how can I make a kind of report in Power BI using AX data?
Please share your knowledge or experiences.
*This post is locked for comments
You can install On-premises data gateway and then build report against AX database, there is nothing specific to AX to know, it's similar to consuming any other SQL database.
Or you can use AX OData query service as described here https://stoneridgesoftware.com/ax-2012-and-power-bi/
Third option is entity store but it requires R3 https://www.daxrunbase.com/2017/06/07/working-with-entity-store-and-dixf-in-ax/
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156