Forum Discussion
Power Query - SKU Generator
Below may help fix Power Query refresh issue:
1. Ensure using “Close & Load To…”
• After building your query, use “Close & Load To…” instead of just “Close & Load”.
• This lets you choose where the query output goes (e.g., a table in a specific sheet).
• If you only used “Close & Load”, Excel might not have created a visible output table, so refresh appears to do nothing.
2. Check Query Dependencies
• If your query depends on another query (e.g., merging Products and SizeMapping), make sure:
o Both queries are loaded properly
o The merge keys (e.g., SIZE RANGE) match exactly—no trailing spaces or mismatched formats
3. Verify Output Table Exists
• Go to the sheet where the query should output.
• If no table is visible, go back to Power Query and re-load it using:
o Home > Close & Load To… > Table > Existing Worksheet
4. Refresh All Connections
• Use Data > Refresh All from the Excel ribbon—not just the Power Query editor.
• On Mac, this is the only way to trigger refresh for all queries.
5. Check for Errors in Applied Steps
• In Power Query Editor, look at the Applied Steps pane.
• If any step shows a warning or error (e.g., merge mismatch, null values), the query may silently fail on refresh.