title: Is there a way to dynamically identify and expand an embedded table's columns?
body: <p>If I want to expand this embedded table...</p>
  
  <p><a href="https://i.stack.imgur.com/AFFlr.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/AFFlr.png" alt="enter image description here"></a></p>
  
  <p>...and I click on the expand button, I'm presented with the dropdown to select which columns I want to expand:</p>
  
  <p><a href="https://i.stack.imgur.com/USBdq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/USBdq.png" alt="enter image description here"></a></p>
  
  <p>However, if I choose '(Select All Columns)' to expand them all, Power Query turns that into hard-coded column names of all the columns at the time I do that. Like this:</p>
  
  <pre><code>= Table.ExpandTableColumn(Source, "AllData", {"Column1", "Column2", "Column3", "Column4", "Custom"}, {"Column1", "Column2", "Column3", "Column4", "Custom"})
  </code></pre>
  
  <p>After that, if the underlying embedded table's columns change, the hard-coded column names will no longer be relevant and the query will "break." </p>
  
  <p>So how can I tell it to <em>dynamically</em> identify and extract all of the current columns of the embedded table?</p>