Combing data with different headers into one table

Anonymous · ‎11-15-2023

Hi,
In Power BI, I am importing data from a folder containing several files that share a similar structure. However, some files have differing headers.Note that headers need to be promoted for all these files. I'm looking to combine all this data into a single dataset. Does anyone know how to do this? Is it something to with sample file on power query editor?

PhilipTreacy · ‎11-15-2023

Hi @Anonymous

Possible but would be much easier to help you with some sample files to work with

regards

Phil

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

Blog :: YouTube Channel :: Connect on Linkedin

Proud to be a Super User!