Forum Discussion
New Column in Excel Table not appearing
Hi, I have added a new column in my excel table (Reading all excel sheet in a folder). On refereshing the data, the column is showing in Query editor till Applied Steps (REMOVED OTHER COLUMN...
Sadr_Hoda how to you add column ......
Yes same. When I have added column in excel sheet and referesh it is added in my dataset and coming (when source data is a single excel sheet with table).
However, in my case, my source data is Folder.files and I have added a new column in all excel sheet, however, as shown in pic, it is read in Power Query editor but not coming in all steps.
Assignment column coming till
But not coming in next step
Looking forward for your advise
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.