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...
RnavalPost Partisan
Post PartisanHere's what I see in Advanced Editor...no column value listed there
MNedix
Solution Sage
Solution SageThat'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.