Connect MySQL to Power BI

Connect MySQL to Power BI step-by-step:

Step 1: Collect data
Connect your MySQL server account and adjust the source settings:

• Enter the name of the MySQL database from which you want to extract data. You need to clarify it because you may have several databases linked to your account
• Provide the name of the table or view you'd like to export

After that, proceed to the next step.

Step 2: Organize and transform
Before you load MySQL to Power BI, preview your data to confirm that it's accurate. If some transformations are needed, here's what you can do:

• Edit, rearrange, hide, or add columns.
• Apply various filters and sort your data.
• Create new columns with custom formulas.
• Blend data from multiple accounts or apps.

This ensures your dataset is ready for analysis right after it is imported.



When you finish that, go next to configure the destination settings.

Step 3: Load and automate
To finish data import from MySQL to Power BI, follow the in-app instructions to generate the integration URL and paste it into the Power BI desktop application.



After that, enable automatic data updates and choose the interval that suits you. Lastly, save and run the importer.

Switch on automatic refreshes to ensure that your imported data remains relevant over time. The key step is to specify how often updates should occur, whether monthly, daily, hourly, or as frequently as every 30 or 15 minutes. To tailor your data refresh even more, specify the days of the week, the time slot, and your preferred time zone.



This Coupler.io feature keeps your report in sync with the dynamic source data at all times.