Forum Discussion

Sadr_Hoda's avatar
Sadr_Hoda
Frequent Visitor
3 years ago

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 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.

 

Need Help

6 Replies

    • Sadr_Hoda's avatar
      Sadr_Hoda
      Frequent Visitor
      3 years ago

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

       

      Any other advise.

      • Mahesh0016's avatar
        Mahesh0016
        Super User
        3 years ago

        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.