Forum Discussion
Post PatronPowerBI not detecting new Excel columns
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
but could not find the delimiter option in advanced editor
any suggestions please
2 Replies
- adudani
Memorable Member
hi abukapsoun ,
when the file is in the csv formatthe 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.
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.
