Forum Discussion
Solved
MySQL: Fatal error encountered during command execution - problem in service and desktop
Hi all, Recently I started having problems connecting to one of my company's MySQL databases. We have a report that worked fine until some days ago during refresh it threw an error: Underly...
Hi all,
Looks like our IT Departament found solution to this problem.
1. I had to instal the connector from this site: https://mariadb.com/downloads/connectors/connectors-data-access/odbc-connector/
2. When connecting to the database in Power BI, I had to use option "MariaDB" instead of "MySQL Database"
This solution worked for me and I hope it will work for other people having this issue.
I assume that you cannot access the DB from a new Power BI file?
Hi RobertPaegelow
No, I cannot access the database in new Power BI file.
I also cannot connect via Excel's Power Query and I cannot refresh already published report that worked some time ago.