March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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.
Solved! Go to 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.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
129 | |
90 | |
75 | |
58 | |
53 |
User | Count |
---|---|
200 | |
104 | |
101 | |
67 | |
55 |