Create a MySQL database user for by following these instructions

https://kb.factorywiz.com/portal/en/kb/articles/create-readonly-user-for-large-screens

Then create a System DNS on your computer by following these instructions

https://kb.factorywiz.com/portal/en/kb/articles/10-2-odbc-installation

Then, log into https://app.powerbi.com and select the “+ New report” option

From there you should be able to click the Download the desktop app link to install Power BI desktop app on your computer.

Open Desktop app and select new Blank report

Select the “Get data from another source” option

Select Other and then ODBC and then click the Connect button

Select the previously configured CyclesDB DSN and then click the OK button (if you do not see the DSN option, then you will need to go back and create an x64 ODBC DSN)

You may want to use a TSQL query to retrieve data from the database. To do that, you would expand the Advanced options and enter the SQL statement
Here is an example that will get the latest summary data for “today”

SELECT * FROM summarydata s WHERE s.UDShiftDate>=CURDATE()

If prompted, enter the database user credentials and click the Connect button

 

If you get the following error message, please make sure your DSN driver is MariaDB 3.2.5 Connector or higher (alternatively, you could install and use the MySQL 9.x ODBC Connector to create the DSN)
https://dev.mysql.com/downloads/connector/odbc/5.1.13.html

Once the query has run and the example data is shown, click the Load button to load that data.

Choose the 100% Stacked Bar chart from the Visualizations area of the Power BI Desktop app to place it on the report surface

Expand the Query1 option in the Data area and drag  the UDCnc field onto the X-axis option to put the CNC name on the X axis

Then drag the UDTotAvailSecs the UDTotAvailRunSecs fields onto the Y-axis (by default they should come across as “Sum of” the field)

Your report should now look similar to this