Hi,
Is it possible to delete a power query via Excel interop? Or stop it refreshing?
My process is Open spreadsheet, Refresh all (get the latest data from SQL Server), Delete connections, send to internal customer.
But I do not want the power query to still be there.
Alternatively is there a different option from power query (and VAB) to call a SQL Stored proc.
Thanks