Forum Discussion
Rnaval
Post Partisan
Post PartisanAdding or Deleting a column in Excel
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...
MNedix
Solution Sage
Solution SageHeya,
Yes. Go to Transform Data (Power Query) -> Select your Table -> Go to Advanced Properties -> in the Let section look for Column = <number> and replace the number with "null" (without quotes) - see below.
RnavalI 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