Forum Discussion
Power BI + MySQL - Unexpected error: Connection must be valid and open
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,
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
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?
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.