Forum Discussion

ivancans's avatar
ivancans
Frequent Visitor
7 years ago
Solved

Power BI + MySQL - Unexpected error: Connection must be valid and open

Hi everybody,   When trying to manipulate (pivot a column) appended MySQL queries, I get "Unexpected error: Connection must be valid and open" message. The weird thing is that even though individ...
Need Help
  • ivancans's avatar
    ivancans
    7 years ago

    Hi v-yuta-msft ,
    It works now because of one of two things. Either new release of Power BI solved it or doing something that helped me with ole db or odbc error, that something being - deleting existing connetion to dwh and creating it from scratch.

ivancans's avatar
ivancans
Frequent Visitor
7 years ago

Hi v-yuta-msft

 

Only SELECT statements. Also, when I tried to paste the error message here it said that it is too long. 

Error happens when Power BI is working on pivoting a column. Is there a place in Power BI from which I could get a different error message for me to show you?

v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

Hi ivancans,

 

You can also trace your query in SQL profiler if you have installed sql server on your machine. If you have solved your issue, could you please kindly mark my answer?

 

Regards,

Jimmy Tao

  • ivancans's avatar
    ivancans
    Frequent Visitor
    7 years ago

    Hi v-yuta-msft ,
    It works now because of one of two things. Either new release of Power BI solved it or doing something that helped me with ole db or odbc error, that something being - deleting existing connetion to dwh and creating it from scratch.