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.