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.
Bookmarks