title: Excel: Is there a way to update the table from power query even if a row is missing?
body: <p>Hope you have a great day. Recently I was trying to create a report in Excel and tried to get the data needed from an HTML file. The HTML file is basically the web page where all the issues are stored then filtered in little tables with what we need for the day. I don't have the option to get the data from web directly since the company does not allow add-ins to log in to the site and grab the data from there and the Get Data from Web does not work since the security of the database pops in and does not let you to get anything, so the workaround was to save the page as HTML every time I need to make the report and overwrite the old one that is connected to the Excel Workbook.</p>
  <p>I managed  to create the needed charts of the loaded tabled from the HTML file into excel, but I stumbled on an issue on the Power Query side. The tables from the page I save the HTML file are not the same, meaning sometimes a column is missing since there was no issues for it and the database will hide it automatically from the table, so when I refresh the query it will display the error &quot;The Column X is missing from the table&quot;. I know it is missing, but I don't want to get the data every time one column is missing and redo everything again so the chart will update correctly.</p>
  <p>Is there a way to make a code in Power Query advanced editor so the table will update anyway even if a column is missing without needing to code/get data every time? What I'm trying to do here is to automate a process so the least amount of work to get the data, the better for me.</p>
  <p>Thanks in advance!</p>
  <p>*Edit: This is the source M code of the query:</p>
  <pre><code>    let
      Source = Web.Page(File.Contents(&quot;D:\AUTO.html&quot;)),
      Data1 = Source{1}[Data],
      #&quot;Changed Type&quot; = Table.TransformColumnTypes(Data1,{{&quot;Customer Impact&quot;, type text}, {&quot;Yes&quot;, Int64.Type}, {&quot;No&quot;, Int64.Type}, {&quot;WIP&quot;, Int64.Type}, {&quot;T:&quot;, Int64.Type}})
  in
      #&quot;Changed Type&quot;
  </code></pre>