Forum Discussion
Error on Refresh
That's pretty easy - in this section:
Find "PRIORITY" in red and change it to "DC Week" - just make sure it matches what's shown in the column header in the step earlier
Amjad1002 That's good - that helps. It doesn't appear that the change types step is the issue - it looks like the problem is earlier in the Applied Steps section. So the thing to check is the Source and Navigation steps. You may need to click the widget icon next to one or both of those and point Power Query to the new location/new sheet name.
You can click on each step to see which one has the issue (basically, is it the Source step or the Navigation step that you'll need to fix). I'm guessing it's the Navigation step and you'd need to point it to the appropriate tab but if the location changed then you may need to update the Source step too. But basically, you want to click through each step until you see the error message appear and that's the step you need to fix.
I just figuer it out. someone change the column name "PRIORITY" to " DC Week". Now I want to update this column name how can I update so that error can be fix