How to Connect MySQL Workbench to Power BI

Getting your valuable MySQL data into a Power BI dashboard is a common goal for teams wanting to visualize business performance. While Power BI lists MySQL as a native connector, making the connection seamless requires a couple of specific steps that often trip people up. This guide will walk you through the entire process, step-by-step, and clarify the potential roadblocks so you can build reports without the headache.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Before You Begin: What You'll Need

To ensure a smooth connection process, make sure you have the following components installed and information ready. This prep work will save you from frustrating error messages later on.

• Power BI Desktop: You'll need the latest version of the free Power BI Desktop application installed on your Windows machine. If you don't have it, you can download it from the Microsoft Store.
• MySQL Workbench (or access to a MySQL database): While you don't technically connect through MySQL Workbench, you need an active MySQL database to connect to. Having Workbench installed is helpful for verifying your credentials and database structure beforehand.
• MySQL Database Credentials: You must know the server name (or IP address), the specific database name you want to connect to, your username, and your password.
• MySQL Connector/NET: This is the most important - and most often missed - requirement. Power BI needs this specific driver to communicate with your MySQL server. We'll cover how to install this in the first step.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Install the MySQL Connector

Power BI doesn't come with the necessary MySQL driver pre-installed. You need to download and install it manually. Think of this connector as a translator that allows Power BI (which speaks Microsoft's language) to understand and communicate with MySQL.

Attempting to connect without this connector is the number one reason users encounter the "MySQL connector not installed" error.

1. Visit the MySQL Website: Go to the official MySQL Connector/NET download page.
2. Select Your Operating System: Choose "Microsoft Windows" from the dropdown menu.
3. Download the Installer: You'll typically see two download buttons. The smaller (online) installer is fine, but the larger "MSI Installer" is generally more reliable. Click 'Download'. You can click "No thanks, just start my download" on the next page to skip the login prompt.
4. Run the Installer: Close Power BI Desktop if it's open. Run the MSI file you just downloaded and follow the on-screen prompts. A "Typical" installation is usually sufficient.

Once the installation is complete, you're ready to open Power BI and make the connection.

Step 2: Connect Power BI to Your MySQL Database

With the connector installed, an actual connection is just a few clicks away in Power BI Desktop.

1. Open Power BI and Select "Get Data": Launch Power BI Desktop. On the Home ribbon, click on the "Get Data" icon. From the dropdown, select "More...."
2. Search for the MySQL Connector: In the "Get Data" window, type "MySQL" into the search box. Select "MySQL database" and click "Connect."
3. Enter Your Server and Database Details: A new window will appear asking for your credentials.
4. Choose a Data Connectivity Mode: Before clicking OK, you have an important choice under "Advanced options":
5. Provide Your Username and Password: After you enter the server/database info, another window will pop up. Click on the "Database" tab on the left. Enter the User name and Password for the database user account that has permission to access the data. Click "Connect."

Common Roadblock: The Encryption Support Error

Sometimes, after entering your credentials, you might encounter an error message that says, "We were unable to connect to the data source using an encrypted connection... To connect, use the 'Encrypt connection' option and set it to 'Optional' or 'None' in the data source settings."

This happens when Power BI's default security requirements don't match your MySQL server's configuration. The fix is simple:

1. Go back to editing the connection details (you can find them under Transform data > Data source settings).
2. Select your MySQL data source and click "Edit."
3. Uncheck the "Enable certificate revocation check" box.
4. Click OK. You should now be able to connect successfully.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 3: Navigating and Loading Your Data

Once the connection is successful, the Power BI Navigator window will appear. This window shows you an organized list of all the tables and views available in the database you connected to. Now you get to choose what data you actually want to import for your report.

1. Select Tables: Check the box next to one or more tables you want to analyze. As you select a table, a data preview will appear on the right side of the window, giving you a quick glimpse of the columns and a sample of the rows.
2. Choose "Load" or "Transform Data": At the bottom right, you have two options:
3. Start Building: Once your data is loaded, the Navigator window will close, and you'll be back in the main Power BI report view. Your tables and columns will appear in the "Data" pane on the right-hand side. You can now drag and drop fields onto the report canvas to start building visuals!

Tips for a Better MySQL and Power BI Experience

Connecting is just the first step. To make your life easier as you build and maintain a report, keep a few best practices in mind:

• Start with a Small Subset of Data: When first connecting, don't try to import a table with 10 million rows. Use the 'Transform Data' step to filter for just the last day or week's worth of data. This allows you to build the report quickly without long wait times, and you can remove the filter later.
• Use Views for Complex Logic: If you need to join multiple tables or perform complex calculations, it's often more efficient to create a SQL View in MySQL Workbench first. Then, in Power BI, you can simply connect to that clean, pre-aggregated View instead of trying to rebuild all that logic in Power Query. This lets your database do the heavy lifting.
• Secure Your Credentials: Never hard-code passwords directly into your Power BI reports if you plan to share the .PBIX file. Manage credentials properly through the Data Source Settings panel.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Final Thoughts

Connecting MySQL to Power BI is a completely manageable process once you know the critical-but-simple requirement of installing the Connector/NET driver. From there, it's just a matter of pointing Power BI to your server, providing your credentials, and picking the tables you want to analyze. This opens up a powerful way to turn your raw database tables into interactive, insightful dashboards.

While this direct connection method is great for deep analysis, we found that marketing and sales teams often struggle when they need to connect more than just one source. Having to repeat this setup process for Google Analytics, Facebook Ads, Shopify, and Salesforce quickly becomes a major time sink. At Graphed, we streamlined this entirely by building one-click integrations that let you hook into all your tools in seconds and get straight to building dashboards with simple, natural language - no database credentials or drivers required.