Forum Discussion
Adding 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...
Here's what I see in Advanced Editor...no column value listed there
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.