Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
seonglf
New Member

how to connect data gateway with mariadb?

Hello.

 

I want to connect data gateway for on-premiss.

 

My database is MariaDB but I can't see connector for mariadb.

 

althought exists mariaDB data source I don't need it.

 

I tried to connect with MySQL but failed.

 

Is there a way to connect with MariaDB?

 

 

seonglf_0-1646876535264.png

 

6 REPLIES 6
Anonymous
Not applicable

Hi  @seonglf ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards

Anonymous
Not applicable

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:yingyinr_0-1647252126893.png

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

Hi @Anonymous 

I also had the same issue with MariaDB. Even though PowerBI platform and service has a dedicated connector, the dataset do not work with  gateway. My requirement was limited to scheduled refresh and hence, I was able to follow your workaround to add it as a ODBC datasource. After this, it got connected with gateway and I was able to setup scheduled refresh. 

 

Still it would be nice if I could have worked with mariadb connector itself and add gateway to datase on power bi service. 

 

Thanks again!!

seonglf
New Member

thank you for your answer!

 

but I have MariaDB connector.

 

What I want is something else.

 

I want to "Data gateway" connector.

 

"Data gateway" is used to reflect data in real time.

Greg_Deckler
Super User
Super User

@seonglf I'm not entirely sure what interface you are in but MariaDB connector exists:

Greg_Deckler_0-1646877461614.png

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

thank you for your answer!

 

but I have MariaDB connector.

 

What I want is something else.

 

I want to "Data gateway" connector.

 

"Data gateway" is used to reflect data in real time.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.