Forum Discussion

Pragati11's avatar
Pragati11
Super User
7 years ago

Dashboard Refresh crashes with MySQL database

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 databa...
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

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's avatar
    Pragati11
    Super User
    7 years ago

    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?