Forum Discussion
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...
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.
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
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.