I would recommend that you evaluate the Sage Data & Analytics solution which is purpose built to support using Power BI with Sage X3.  It includes a reporting ready pre-built X3 data model, many pre-defined KPIs, out of the box Power BI dashboards, smart data modeling capabilities, a security model for the X3 data, and more.  It may be more than what you need as described in this post, but depending on your longer term needs it could be a fit.

I would recommend that you evaluate the Sage Data & Analytics solution which is purpose built to support using Power BI with Sage X3.  It includes a reporting ready pre-built X3 data model, many pre-defined KPIs, out of the box Power BI dashboards, smart data modeling capabilities, a security model for the X3 data, and more.  It may be more than what you need as described in this post, but depending on your longer term needs it could be a fit.

Thank you for your answer and recommendation Steve. Where can I find the solution you suggested? Could you share a link please?

Hi Farren Collins ,

Here are some links you can review.  Each link contains some unique content.  The last link is a link to the Sage US Marketplace.  You should check the Sage Marketplace in the country in which you reside.

• https://www.zapbi.com/sage-x3
• https://www.zapbi.com/platform-overview
• https://us-marketplace.sage.com/en-US/apps/53095/sage-data-analytics/overview