Forum Discussion

alish_b's avatar
alish_b
Super User
2 years ago

Unable to Fold Query using MariaDB Direct Query Adapter for Power BI

I installed the mariadb-connector-ODBC-3.1.20-win64 ODBC connector and used the MariaDB connector in Power BI. Then I used the Direct Query mode to connect to the database. I was able to pull some o...
Need Help
ahmola's avatar
ahmola
Regular Visitor
2 years ago

Hi alish_b. 

 

I'm using mariadb too and I have the same problem here.

There is a temporary solution that I can apply which is exporting the data to a csv, or json file dicrectly from the database, and then import that file to Power Bi instead of connecting directly to mariadb. I know it's not a very practical way, but that's the solution that prefere instead of Import mode in powerbi that takes about 35 minutes to load only 50k rows of data every time I refresh.

 

If you have any updates please share here.

 

Thanks.