363
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
I have the same question (0)
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/
Share
Report
All responses (
Answers (
