When a table is created in Excel, Power Query assumes that all data belongs in table rows. However, a data source might have a first row that contains column names. To make sense of the data, you might need to promote the first table row to column headers.
For more tips like this, check out the working remotely playlist at www.youtube.com/FoetronAcademy . Also, if you need any further assistance then you can raise a support ticket and get it addressed.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article