cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Artex
Frequent Visitor

Mariadb connector in on permise Gateway

I've created report with Mariadb live connection, published to Powerbi online (Pro license). How should I setup datasource for on permise Gateway (October 2020 update)? I'm trying to add new datasource to Gateway, but there are no Mariadb connector in list, only Mysql and report is not working, message:

To use a data gateway, make sure the computer is online and the data source is added in Manage Gateways. If you're using an On-premises data gateway (standard mode), please select the corresponding data sources and then click apply.

4 REPLIES 4
uk_tj
Advocate IV
Advocate IV

Hi Artex,

I've just set this up and in order to add the data source to the gateway you need to install the mariadb ODBC & connector and copy the .mez file from the connector installation to wherever your gateway looks for custom connectors.

"C:\Users\PBIEgwService\Documents\Power BI Desktop\Custom Connectors"

Then restart the gateway and you should now be able to add this data source.

uk_tj_0-1605781750616.png

 

Artex
Frequent Visitor

Hi, thanks for the hint, I've tried to reproduce, but unable to find .mez file. As I understand .mez it is PBI connector file and I should search the file on my desktop computer with PBI desktop. I found 3 files at

C:\Users\myuser\Microsoft\Power BI Desktop Store App\CertifiedExtensions

JethroData1.0.1.mez
TeamDesk.PowerBI.DataConnector.mez
Exasol.mez

is it wrong location?

 

and second issue - unable to install latest driver version (MariaDB Connector/ODBC 3.1.10 ) on gateway server with old windows 2008. managed to install 3.0.9 version.

v-stephen-msft
Community Support
Community Support

Hi @Artex ,

 

Please kindly refer to this post:

 

https://community.powerbi.com/t5/Service/Add-MariaDB-ODBC-to-on-premise-Gateway/m-p/1203825/thread-i...

 

I think you may try ODBC Data Source Type to connect you Mariadb.

 

 

 

Best Regards,

Stephen Tao

 

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

ODBC Data Source is useless, it does not support live/direct connections.

I can use Mysql Data Source to use mariadb database in Import mode, but Import mode limiting refresh count. Powerbi October 2020 update added Mariadb with live connection support, but I do not understand how the Maridb connector should be used. Maybe Maridb connector support in Gateway will come later ?

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors
Top Kudoed Authors