Adding/Removing Columns to a Web Based Excel Source

[vinnysilva]

Hey everyone! I currently have a report which uses as "Web" data source (source is an Excel file housed in Teams, I used Web to connect them.) When I open the Excel source file, and try to add or remove a new column, it soemtimes causes erroer messages as well as the new/removed column will not reflect in PowerBI. Because my source is technically "Web" as I conncedt the file path to an Excel document in Teams, some solutions mentioned on here do not work. Does anyone know how to deal with this issue and prevent it from occuring. Thanks!

[amitchandak · Accepted solution]

@vinnysilva , Ideally the new version of power bi, it should automatically take care of add remove columns

How to manage when column is added or removed at source: https://www.youtube.com/watch?v=h0yLtceT0i4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=2