Power BI Not picking up additional column in Excel data source

[mightydnb]

Hi

I've added an additional columm to the Excel spreadsheet that is my data source, but Power BI isn't (automatically) picking this up when the data is refreshed - viewing the table in Power Query doesn't show this column.

How can I add this extra column please?

[bhelou]

Dear , 

1- In your excel , define the data into table and give the table a name ( in Table Design then Table Name  )  , in this way everytime you insert a newcolumn it will be included in the table , 
2- check the new column if it is included in the table  
3- check in Power Queries in the applied steps  if you made remove other columns .
4- Check for error in the table load from the source 

Regards, 

Kindly accept as a solution and a kudo if it works with you