Can't retrieve tables with MariaDB

[gauber]

Dear community,

I am struggling with retrieving tables from MariaDB server in Power BI Desktop.

I have created a new source and I can see all databases, but when I click on a database I can't preview any tables.... The account has been granted full priviledges on the DB.

I've tried to connect directly and also using ODBC connector. Same result.

I am using Desktop v 2.98.1025,

Latest ODBC connector: 3.1.15

et MariaDB 10.3.9

What am I missing ?

[gauber · Accepted solution]

Thanks for the reply. I managed to fix it. It was a MariaDB right issue. I gave rights to access the database, not tables !

[amitchandak]

@gauber , On the same machine, please check using MySQL Workbench and check are you able to see any data. I doubt some IP whitelsiting issue