Connect Power BI Desktop

Microsoft Power BI is an interactive data visualization software product developed by Microsoft with a primary focus on business intelligence (BI).

Step 1: Create Site Database User

You need to first generate a database user for your site. Follow this documentation to create a read-only user.
Typically, it takes a few seconds to configure the database user. Once it's complete, click on View Credential.

Download MariaDB ODBC Connector v3.1.x (Download link).
Note: Please avoid installing v3.2.x as it has a bug that causes it to not work with Power BI.
Install ODBC Connector.

Open ODBC Data Sources with Run as administrator.
Note : If you have installed ODBC connector of x64 version, then you should open ODBC Data Sources (64-bit) and if you have downloaded and installed x32 version, then open ODBC Data Sources (32-bit)
Click on Add button in User DSN tab.
Choose MariaDB ODBC 3.1 Driver.
Put the Server Name , Port, Use Name , Password, Database in the required fields and go to next page.
Note: Currently If you try to click on Test DSN, it will fail. We need to do few more configurations to make it working.
No information is needed on the current page. Proceed to the next page.
No information is needed on the current page. Proceed to the next page.
In current page, make sure to check Verify Certificate & Force TLS Use checkbox.
No information is needed on the current page. Click on Finish to save it.

Open Power BI and click on Get Data From Other Sources.
Search for ODBC and click on Connect.
Choose the ODBC connection from the list. It should be the same you have created in ODBC Data Sources Administrator in Step 3.
Now, it might ask you for username and password. Choose Windows from the sidebar and click on Connect.
Once connected, you will be able to view all the tables and their previews.
Now, follow the official documentation to create dashboards and reports in Power BI.