Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I am using Power BI to create a dashboard.
The dashboard uses MySQL database connection to connect to data and use this data to create reports on dashboards.
Data from the MySQL database is retrieved by writing individual queries in Power BI Query Editor, in-order to avoid loading whole data from the database.
I am getting the following issue while refreshing my dashboard:
"MySQL: fatal error encountered during command execution"
I have tried some ways suggested on Microsoft Power BI blog to fix this issue.
But, in this case these doesn't seem to work.
One thing to note here is the data we use, keep on increasing on daily basis. It is the daily activity of users captured on a website.
Can you please help us to fix these issues in Power BI?
Hi @Pragati11,
I could not reproduce your problem on my side. Only when I set variables incorrectly in custom query code, this error was prompted when trying to connect to database.
In your scenario, did you set variables? Could you post the code here?
Besides, please test to load whole data from database without writing individual queries, to check if issue persists when refreshing.
Regards,
Yuliana Gu
Hi @v-yulgu-msft,
Thank you so much for your reply.
Just a question here: What do you mean by setting variables incorrectly?
In my case the tables are like very big on the database nearly 3-4 GB already. And the data on them keeps on increasing on daily basis.
If I load the whole table will it not make Power BI much slower?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.