How to vizualize promoted Headers after Combining files in Power Query?

[Anonymous]

Hello everybody,

I spent a whole day trying to figure out a way to properly prepare my Data in Power Query and I really need your help.

I have 2 data files at the moment.

In "APPLIED STEPS" in Power Query, after having entered the "SOURCE"(Sharepoint link) and filtered rows (File names), I clicked on "combine files" in order to get 1 single table with data. The problem is that this very way doesn't allow you to have "Promoted Headers" in "Applied steps". I really need that step in order to insert a new step with "Table.ColumnNames" formula.

How can I achieve that? Is it possible to have "Promoted headers" after "Combining files" or there's another way to approach this issue?

Thank you in advance for your precious time and attention.

Best regards,

Edgar.

[Anonymous]

Hi @Anonymous 

In the auto-created step, find the last step before the merge step, after which you need to manually add a new step to promote the title

PromotedHeaders = Table.PromoteHeaders(CombinedFiles, [PromoteAllScalars=true])

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.