Adding or Deleting a column in Excel

Question

I'm using an excel file and when I add or delete a column, the change does not automatically appear in Power BI, I get errors when refreshing data. Is there a seamless way to make changes to my excel file without causing Power BI issues when refreshing?

mnedix · Answer

That's strange, are you sure that if you add a new column in Excel source file and save it, and then open the PowerBI file and refresh the query the new column does not appear?
If it still doesn't work, try compying the xls locally and repeat the above test. It may have something to do with how the file is brought from Sharepoint.

mnedix · Answer

Heya,
Yes. Go to Transform Data (Power Query) -&gt; Select your Table -&gt; Go to Advanced Properties -&gt; in the Let section look for Column = &lt;number&gt; and replace the number with "null" (without quotes) - see below.

&nbsp;

rnaval · Answer

I don't see the Advanced Properties option, I see an error message that column 22 was not found. I can get into the advanced editor but there is no option for column specified there