Connecting Frappe Cloud Database to Microsoft Power BI

You can connect your Frappe Cloud database to Microsoft Power BI using the MariaDB ODBC Connector. This allows you to build interactive dashboards, reports, and visualizations using your ERP data.

Step 1: Create a Database User

Before connecting Power BI, create a read-only database user for your Frappe Cloud site.

1. Create a read-only database user using the Database Users and Permission Manager.
2. Wait for the configuration to complete.
3. Click View Credential to obtain the connection details.

You will need the following information during the ODBC configuration:

• Server Name
• Port
• Database Name
• Username
• Password

Step 2: Install the MariaDB ODBC Connector

Download and install the MariaDB ODBC Connector v3.1.x.

Complete the installation using the default installer options.

Step 3: Configure the ODBC Data Source

After installing the connector, create an ODBC Data Source.

1. Open ODBC Data Sources as an administrator.
2. Use the version that matches the installed connector:
   • ODBC Data Sources (64-bit) for the 64-bit connector.
   • ODBC Data Sources (32-bit) for the 32-bit connector.
3. Open the User DSN tab.
4. Click Add.
5. Select MariaDB ODBC 3.1 Driver.

Configure Connection Details

Enter the following information:

• Server Name
• Port
• Username
• Password
• Database Name

Continue through the remaining configuration pages without making any changes until you reach the SSL configuration screen.

Configure SSL Settings

On the SSL configuration page, enable the following options:

• Verify Certificate
• Force TLS Use

After enabling both options, click Finish to save the ODBC connection.

Step 4: Connect Power BI to the Database

After creating the ODBC connection, configure Power BI Desktop.

1. Open Power BI Desktop.
2. Click Get Data.
3. Search for and select ODBC.
4. Click Connect.
5. Select the ODBC Data Source you created earlier.

Authentication

If prompted for authentication:

1. Select Windows from the authentication options.
2. Click Connect.

Once the connection is established, Power BI will display all available database tables along with preview data.

Next Steps

After successfully connecting your database, you can:

• Import ERP data into Power BI.
• Create reports and dashboards.
• Build interactive visualizations.
• Analyze business data using Power BI’s reporting tools.