Forum Discussion
ADD A COLUMN WITH THE FILE NAME
Hello, I'm facing this problem: I imported two different databases with powerquery from two files in the same folder; in the two files there is an important information missing but it is contained in...
Before expand Content be sure you have column as.
Expand Content, scripts will be generated and in main query you have steps like this
Depend on which columns did you keep before transformation and Power Query version it could keep could not column with file names. If not check Remove Other Columns step and correct it in formula bar (or remove at all and insert your own step which keeps proper columns).
