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

[ivancans]

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 individual queries (consisting of this year's months)are working AND append with first six months of the year is working, for the last months it does not. Connection type and settings have not been changed. Connection was made with MySQL database.

I have no idea how to solve this. If you need any other detail from, please ask.

[v-yuta-msft]

Hi ivancans,

Are you trying to write query like "insert" in sql statement in power bi desktop when connect to mysql. If you are, this is not supported in power bi, you can only write sql statement like "select from where". In addtion, if error happens during data refresh in power bi, could share your connection string and error messages in trace logs?

Regards,

Jimmy Tao

[ivancans]

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]

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 · Accepted solution]

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.