How Develop your own Dashboard from AX with SQL support

            Power-BI is a tool, which is developed by Microsoft and that shows you the user-friendly dashboard. It makes you the attractive Dashboards to the Top managements who are all not satisfied with the AX Dashboard. The main source data is pull from SQL or any other authorized Database.

            By using the query you can get the data within a fraction of seconds, or else you can put it in the auto-refresh mode sample query is listed below. Write the view query from SQL knowledge to develop the reports.

            i.e:

CREATE VIEW vw_Report AS
SELECT Department1, Department2, ...
FROM Table_Company
WHERE condition;

Below query is viewed to developed reports from SQL itself.

                                   

            i.e: SELECT * FROM vw_Report

            End-user also can develop the reports, if they know the basic functionalities on the Technical knowledge.

License Details:

            You have 60 Days trial pack is there you work from there and get the reports and by default License is there in the Office 365 you need to enable that option from the License, we can integrate with this, for few more advanced customizations we need to buy the license.

From SQL table you need to get the data and collect the information’s and show you for the reports / Dashboard.

SQL query integrations and about the mapping on PowerBI, will show you in the next article soon.