Does My VBA Code To Refresh CSV Power Query Connections Need To Change for MySQL Queries?

I use VBA to open an excel file and refresh the power query connections. The code works fine when I'm connecting to a CSV file as the data source but recently I switched the query to a MySQL data source. Since I did that I'm getting "Application-defined or object-defined error" on the .Refresh line.

When I open the file and push refresh on the MySQL connection the query refreshes with no problems. Does something need to be changed?

Please Login or Register  to view this content.

Originally Posted by sktneer

This worked for me...

I was getting a lot of inconsistent results and tbh its possible there was too much data.
I ended up switching the code up anyway which seemed to give me better performance.

Please Login or Register  to view this content.