PowerBI not detecting new Excel columns

[abukapsoun]

Hi, 

I have a dashboard based on an excel sheet. However once I add aditional column to excel, powerBI is not detecting it. 

I tried the following post 

https://community.powerbi.com/t5/Desktop/Power-Bi-does-not-detect-newly-added-columns-to-connected-c...

but could not find the delimiter option in advanced editor

any suggestions please 

[Seban]

I was facing the same problem. The issue was i had removed all the other columns except the Columns i needed Earlier in Power Query. Check in the Applied steps box on the Right whether you have "Removed other columns" as a step. If you have that just remove that and you can see all the columns in source file. 

[adudani]

hi @abukapsoun ,

when the file is in the csv format

the source step looks like :

= Csv.Document(File.Contents("filepath"),[Delimiter=";", Columns=17, Encoding=65001, QuoteStyle=QuoteStyle.None])

when its in excel format to a sheet, it looks like:

= Excel.Workbook(File.Contents("filepath"), null, true)

In this case, the Navigation step should contain the whole imported sheet's contents.

if the file is converted to .csv and you get data from it, you will find the "delimeter" option.