cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
v-yiruan-msft
Community Support
Community Support

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-yiruan-msft
Community Support
Community Support

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-yiruan-msft 

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

 


@ 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!:
Mastering Power BI 2nd Edition

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.