New Column in Excel Table not appearing

[Sadr_Hoda]

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 COLUMNS 1) as below. 

However, the columns is not appearing in next step as below:

and in power BI desktop

In summary, I have added a new column in my excel table data and on refereshing the data, column is showing in Power Query but not coming as a field in Power BI.

Any advise.

[Mahesh0016]

@Sadr_Hoda I hope this post helps you.

[Sadr_Hoda]

@Mahesh0016  I have referesh the data multiple times but column is not appearing in it.

Any other advise.

[Mahesh0016]

@Sadr_Hoda  i have try my side it is show me in desktop . i have add one column in my excel sheet then save and close >> after add column back to desktop and just refresh my dataset.

[Mahesh0016]

@Sadr_Hoda how to you add column ......

[Sadr_Hoda]

@Mahesh0016 

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

[Mahesh0016]

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.