Forum Discussion
Problem using MariaDB datasource in PowerBI online through gateway
We're having an issue connecting reports to gateways, when the reports are using MariaDB datasource.
Gateway version(s): 3000.138.3. The custom connector from MariaDB has been installed on the server, where the gateway is installed.
The error we're presented with is the following
The datasource has been added to the gateway cluster, through PowerBI online and the status says online, when checking through "Manage Gateways".
What are we missing?
2 Replies
Hi 2operate
For the on-premises data gateway, you need to create a data source for your custom connector. On the gateway settings page in the Power BI service, you should see an option when you select the gateway cluster to allow using custom connectors with this cluster. Select that option to enable using custom connectors with this cluster.
When this option is enabled, you see your custom connectors as available data sources that you can create under this gateway cluster. After you create a data source that uses your new custom connector, you can refresh Power BI reports by using that custom connector in the Power BI service.
Besides, please consider some limitations of custom connector:
- Make sure the folder you create is accessible to the background gateway service. Typically, folders under your user’s Windows folder or system folders won’t be accessible. The on-premises data gateway app shows a message if the folder isn't accessible. This instruction doesn't apply for the on-premises data gateway (personal mode).
- For custom connectors to work with the on-premises data gateway, they need to implement a “TestConnection” section in the custom connector’s code. This section isn't required when you use custom connectors with Power BI Desktop. For this reason, you can have a connector that works with Power BI Desktop, but not with the gateway. For more information on how to implement a TestConnection section, see this documentation.
- If your custom connector is on a network drive, include the fully qualified path on the on-premises data gateway app.
- You can only use one custom connector data source when working in DirectQuery mode; multiple custom connector data sources will not work when using DirectQuery.
Refer to:
Use custom data connectors with the on-premises data gateway - Power BI | Microsoft Learn
TripPin 9 - Test Connection - Power Query | Microsoft Learn
Custom Data Connector: How to Deploy and Test - Microsoft Power BI Community
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Thank you for the reply, however all this should be in place, as also shown on the first picture. The problem might be that we shouldn't need a "custom connector".
MariaDB is available as a datasource and we've created this on two different Gateway clusters, yet we're still seeing the problem.
