title: My power query isn't deleting uneeded columns
body: <p>I've got a power query that returns a dynamic number of columns.</p>
  
  <p>If I step through the following steps.</p>
  
  <ol>
  <li><p>Refresh the query which generates a table with 13 columns</p></li>
  <li><p>Refresh the query which generates a table with 8 columns</p></li>
  </ol>
  
  <p>I find that the table generated in Excel has the 8 columns I expect, plus 5 entirely blank columns left over from the first refresh. I have tried a number of steps including changing the connection settings and the table properties. If possible I'd like to avoid VBA.</p>
  
  <p>Does anyone have any suggestions?</p>
  
  <p>EDIT: This behaviour can be replicated by adding additional columns on any query, I believe, and then pressing refresh. In my scenario they are just leftover from the query previously returning more columns.</p>
  
  <p><a href="https://i.stack.imgur.com/3K9Cl.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3K9Cl.png" alt="enter image description here"></a></p>