1

I am using Power Query for Excel and I am trying to connect MySQL database which is hosted on AWS. While trying to connect, I am getting an ERROR in query editor saying "DataSource.Error: Object reference not set to an instance of an object."

My Excel and Power Query both has 32-bit version.

Is there any issue in setting up Data Source?

Thanks

Improve this question

2 Answers 2

Reset to default
1

Just had the same problem. 64 bit Excel and latest version of PowerQuery. The cause of mine was that I had copied and pasted the output of a PowerQuery query into a new Excel sheet. This created a shadow second data connection invisible to the PowerQuery pane.

To fix it I had to go to the Data ribbon > click Connections, highlight the second query (named [YourQueryName]1) and click the Remove button. After that things went back to normal.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

0

You may want to Send-A-Frown from inside Power Query to get in direct contact with the developers.

Please check that you have the latest version of Power Query installed. It might help to upgrade MySQL drivers too.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.