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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Cuatexoft
Frequent Visitor

PowerBi error on MariaDB Direct Query Dataset

I created a  directquery dataset in PowerBI Desktop connected to our MariaDB database using the MariaDB ODBC,  then I published it and our IT team created the Connector in the Gateway, and I created a new MariaDB Data Sourse using my database server credentials, the Data Source appears Online 

Cuatexoft_0-1672895124751.png

but when I enter to the dataset Settings I got this message 

 

We cannot discover all data sources in this dataset right now because the dataset uses a customer connector. Make sure the data gateway associated with this dataset is online and has the custom connector loaded, then click again on Discover Data Sources. Learn more

Discover Data Sources

 

When I click to Discover Data Sources I got this error

 

 Unable to determine the data source. When custom connectors are used, the error can happen if gateway doesn't have the extension enabled. Details: Static analysis failed in gateway. gatewayObjectId:527c76f5-9850-42ef-9603-efce282a77e7, resultCode:FailedWithUnknownOrUnsupportedDataSources Query contains unsupported function. Function name: MariaDB.Contents .Learn more

 

Any Idea about what is happening and how to solve it?

6 REPLIES 6
Anonymous
Not applicable

Hello, 

 

For our case we had to remove the third argument in the datasource (which is null), so change your datasource from MariaDB.content("xxx.xxx.xxx.xxx",databasename,null) to MariaDB.content("xxx.xxx.xxx.xxx",databasename"), the issue will be resolved on the powerbi service and you could now see and configure the gateway section on the dataset parameters.

JNP
Advocate I
Advocate I

Any luck i have the same issue?

Cuatexoft
Frequent Visitor

Hi, sure, I got it solved, the issue was that the Cloud team was using an old old On-premise Gateway version, so 

  1. Upgrade your on-premise Gateway to the latest version (if no already done):

Update an on-premises data gateway | Microsoft Learn

 

Hopefuly this works for you!

Regards

Josue O

Okay Thanks i will try that tomorrow !👍

AbbasG
Memorable Member
Memorable Member

@Cuatexoft had a similar issue, check your gateway connection, if it is connecting to the same one that was created by your IT team.

It is using MariaDB Connector with Direct Query

Cuatexoft_0-1672934526670.png

 

 

So no Gateway settings in the Data Set 

Cuatexoft_1-1672934583131.png

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors