•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Helper query source not updating in Power Query.
I have two queries in an Excel worbook: a main query and a helper query that was created automatically when merging files from the data source folder.
When I change the data source via the corresponding function on the Excel ribbon and refresh all, the source of the main query updates correctly. However, the source of the helper query remains unchanged, which causes it to break.
is there a way to change the data source also for the helper query without having to update it manually in the advanced editor?
[link] [comments]
Want to read more?
Check out the full article on the original site