Adding or Deleting a column in Excel

[Rnaval]

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?

[Anonymous]

Hi @Rnaval ,

Based on the description, when add a column in excel file, saving the change. the added column data appear in Power BI when refreshing data.

The number column appear in Power BI when refreshing data.

Besides, try to check the adding or deleting data in the excel.

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Rnaval]

Unfortunately, it doesn't work for me, I get an error message.

[MNedix]

The Advanced Properties are on the Home tab of Transform Data in PowerBI. You are probably looking at Excel.

[Rnaval]

Here's the Transform Data window / Home tab, not seeing Advanced Properties...

[MNedix]

Sorry, it was Advanced Editor

[Rnaval]

Here's what I see in Advanced Editor...no column value listed there

[MNedix]

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]

Heya,

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.

[Rnaval]

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