Skip to main content
All CollectionsProfit Genius
Connecting Seller Labs MySQL Connector to Power Query
Connecting Seller Labs MySQL Connector to Power Query
Denis avatar
Written by Denis
Updated this week

Follow these steps to connect the Seller Labs MySQL database to Power Query in Microsoft Excel or Power BI:

Step 1: Gather MySQL Connection Details from Seller Labs

Before setting up the connection, ensure you have the following details:

  • SQL Host Server: The MySQL server hostname provided by Seller Labs (e.g., servername.data.sellerlabs.com).

  • Port: The port number for the MySQL server (default: 6603 unless specified otherwise).

  • Database Name: The name of the database you want to connect to.

  • Username: Your MySQL username provided by Seller Labs.

  • Password: The corresponding password for your MySQL username.

You can get these from the Seller Labs Data Hub page. If you do not see them there, feel free to check these instructions on how to establish the connection.

Step 2: Install the MySQL Connector

Power Query requires the MySQL ODBC connector to communicate with the MySQL database:

  1. Download the MySQL Connector/ODBC from the MySQL Downloads page.

  2. Install the appropriate version (32-bit or 64-bit) that matches your Power Query or Excel installation.

Step 3: Open Power Query

For Excel:

  1. Open Microsoft Excel.

  2. Navigate to the Data tab.

  3. Select Get Data → From Database → From MySQL Database.

For Power BI Desktop:

  1. Open Power BI Desktop.

  2. On the Home tab, select Get Data → More....

  3. Search for MySQL Database and click Connect.

Step 4: Configure the Connection

  1. In the MySQL Database dialog:

    • Server: Enter the Seller Labs MySQL hostname (e.g., servername.data.sellerlabs.com).

    • Database: Enter the name of the database provided by Seller Labs.

  2. Advanced Options (Optional):

    • If you want to execute a custom SQL query, you can input it in the SQL Statement field.

  3. Click OK to proceed.

Step 5: Enter Credentials

  1. When prompted, enter your credentials:

    • Username: Enter your Seller Labs MySQL username.

    • Password: Enter your Seller Labs MySQL password.

  2. (Optional) Check Encrypt connection if Seller Labs requires SSL or encryption for connections.

  3. Click Connect.

Step 6: Select Data

  1. If the connection is successful, Power Query will display the available tables and schema from the Seller Labs MySQL database.

  2. Select the table(s) or fields you want to work with.

  3. Click Load to import the data or Transform Data to clean or shape it in Power Query Editor.

Step 7: Troubleshooting Tips

  • Connection Errors:

    • Verify the hostname, port, username, and password.

    • Ensure your machine has access to the Seller Labs MySQL server (check firewall and network settings).

  • Driver Issues:

    • Ensure the correct version of the MySQL ODBC connector is installed (32-bit or 64-bit, depending on your software).

By following these steps, you can successfully connect Seller Labs MySQL to Power Query and start analyzing your data in Excel or Power BI.

Need help? Our support team is happy to assist you! 🙂

  • Connect via the in-app chat icon, located in the bottom-right of your screen while logged into any of our apps

  • Search the Knowledge Base to see if your question has already been answered

  • Make an appointment with us for more direct support

Sign Up for Seller Labs

*No Credit Card Needed

Did this answer your question?