Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register 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!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
121 | |
79 | |
47 | |
45 | |
36 |
User | Count |
---|---|
179 | |
89 | |
69 | |
47 | |
47 |