Connect MySQL to Power BI through your own Azure data warehouse
MySQL data in your warehouse
Yres reads a MySQL database through a direct connection: host, port (3306 by default), the name of the schema or database, and an account with read access. If MySQL is publicly reachable, Yres uses the Azure Data Factory cloud runtime; if the server is on-premises or behind a firewall, you pick a self-hosted integration runtime. Per table you decide which columns are included and whether it loads in full or on changes only. The data arrives with history in an Azure SQL database in your own tenant, ready for Power BI.
At a glance
- Connection
- Direct database connection: host, schema or database name, port, user name and password
- Default port
- 3306
- Network
- Publicly reachable: cloud runtime. On-premises or behind a firewall: an installed and published self-hosted integration runtime that can reach the MySQL server
- Load types
- FULL, DELTA, DELTAIMAGE, IMAGE, OVERWRITE, RELOAD and ADDITIONAL
- Incremental loading
- Yes, also on two change columns at once (same data type; the highest value counts)
- Permissions
- A separate service account with read-only access to the database in question
- Secrets
- Password and connection details go to the Azure Key Vault in your own Azure environment; the Yres web app does not store them
What you arrange yourself
- 1Decide which database you want to connect; SHOW DATABASES; lists the available names.
- 2Get the host and port from your administrator or hosting provider, or take them from an existing connection string.
- 3Create a MySQL account that may only read that database.
- 4Is MySQL on-premises or behind a firewall? Then first install and publish a self-hosted integration runtime that can reach the server.
- 5Add the MySQL source in Yres with the right integration runtime, refresh the metadata and add tables.
When you need this — and when you don't
A standalone connector is enough if…
If a single web shop or application runs on MySQL and you only want to see the current figures, a direct connection or an export will take you a long way.
Yres adds value if…
Yres earns its place when you want to bring application data from MySQL together with your financial and other sources, when tables grow so large that you only want to fetch the changes, or when you want to see what an order, customer or price looked like earlier.
Frequently asked questions: MySQL
Can Yres load incrementally from MySQL when a table has both a created and an updated column?
Yes. Like the other database sources, MySQL supports two change columns. They must share the same data type; per row the higher of the two counts. A new record where only the created column is filled is therefore not skipped.
What goes into Database name: a schema or a database?
In MySQL those are the same thing. You enter the name of the schema, in other words the database, you want to load from. SHOW DATABASES; lists the available names, or ask your administrator.
Our MySQL server is not reachable from the internet. What do we need?
A self-hosted integration runtime that can reach the MySQL server. It has to be installed and published before you create the source; you then select it when adding the source.
Do I have to load entire tables, or can I leave columns out?
Per table you tick the columns you want to load; at least one. Per column you can also set whether a change in that column should produce a new version of the row, and adjust the target type in the data warehouse.
Full technical description in the knowledge base →·Last reviewed:
Data warehouse automation that runs in your own Azure
Built for organisations on Azure and Power BI. Yres connects your sources, keeps the history and promotes changes in a controlled way, without manual work.