This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi There,
The program we use for Incident and Data reporting allows us to export data which is great for analysis via power query. I spent some time developing the query for the regular exported files, all going well until they updated the program to version 4 and the headings are different in the export files.
Can you help me with a possible solution so that my power query will accept the new style of export files?
I have attached spreadsheets to show the before and after headings and hope this can be solved. I would be very grateful for any advice.
Many thanks
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
It is better to recreate that query for new source file.
Or you may use a formula to restructure your new source file to the same as old one. Then you can use your old query.