Dashboard Refresh crashes with MySQL database

[Pragati11]

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?

[v-yulgu-msft]

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

[Pragati11]

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?