1. Install Power BI Desktop on a machine
  2. Download the ODBC connector for MariaDB from the official site (Same principle for MySQL)
    • Note- Please install version : mariadb-connector-odbc-3.1.13-win64.msi
    • :smiling_imp: The latest version: mariadb-connector-odbc-3.1.14-win64.msi has a bug - It crashes the ODBC Data Source utility while connection.
  3. Installation classic of mariadb-connector-odbc-3.1.13-win64.msi.
  4. Click the start button and search “ODBC Data Source (64 bit)” and lauch it with admin privilege.
  5. click add and in the Create New Data Source window select the MariaDB ODBC 3.1 Driver and click on Finish button
    • image
    • Connection Name : glpi-test
  6. In the Next window Enter the requested information (in my case)
    • Server Name: IP of the server
    • Port :3306
    • User name
    • Password * image
  7. click on the button TestDSN ,If the test is successful, a message tells you so and you can choose your database -> choose Glpi from the dropdown.
    • image
  8. Open the PowerBI file and click on the refresh button on the ribbon menu, a window pops up and demands for the database password. Please fill in the respective info and thats-it.
  9. Enjoy!:smiley: