how to connect data gateway with mariadb?

Hi seonglf ,

You can refer the following links to add MariaDB to gateway:

Add MariaDB ODBC to on premise Gateway

---

1. BI connector is a general concept including many kinds of connectors, when you add a new data source        to gateway, I think you should choose ODBC data source type in this issue;

2. When you set connection string, the Connection string field should be like DSN=your dsn name:

You can refer this issue about setting ODBC datasource in gateway: Add ODBC datasource to gateway 

---

2. Publish Real-Time MariaDB Data to PowerBI.com

---

1. Set Up the Gateway

Follow the steps below to configure the gateway on your machine:

1. Run the CData Power BI Connector installer. If you have not already done so, download the Power BI Gateway.
2. Select the on-premises data gateway (recommended) option.
3. Sign into the gateway.
4. Name the gateway and specify a recovery key.

5. In the Connectors step, choose a folder where the gateway will look for the CData Power BI Connector. This article uses C:\Users\PBIEgwService\Documents\Power BI Desktop\Custom Connectors\. Copy the .mez files for the CData Connector (found in C:\Users\USERNAME\Documents\Power BI Desktop\Custom Connectors\) to the folder you configured.

   NOTE: The account configured for the service (NT SERVICE\PBIEgwService) needs to be able to access the folder chosen for the gateway. If needed, you can change the service account in the Service Settings section of the gateway installer.

6. Confirm that the entry CData.PowerBI.MariaDB is displayed in the list in the Connectors section.

2. Connect to MariaDB Data from PowerBI.com

1. Add a data source to the gateway: Log into PowerBI.com and from the Settings menu, select Manage Gateways and select your gateway.
2. Select the option to "Allow user's custom data connectors to refresh through this gateway cluster."
3. Click Apply to save your changes.
4. Click the option to add a data source to the gateway.
5. In the Data Source Settings section, enter a name for the data source and in the Data Source Type menu select CData Power BI Connector for MariaDB.
6. In the Data Source Name box that is displayed, enter the system DSN: CData Power BI MariaDB.

---

Best Regards