To refresh Power Query automatically when the source data changes, you can use a macro. Here’s how to do it: 1. Press `ALT + F11` to open the Visual Basic Editor. 2.

Name Required/Optional Data Type Description; BackgroundQuery: Optional: Variant: Used only with QueryTables that are based on the results of a SQL query.True to return control to the procedure as ...