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 SageSorry, it was Advanced Editor
RnavalPost Partisan
Post PartisanHere'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.