Data export problem, rename column

[Elie_HUCHET]

Hello,
I have a problem with my export from Excel to Power Query.

When I created the PBI, the column in my Excel was called "Product Type" now it's called "Product". Therefore, Power Query shows a problem for the export.
My question is how to make the software now take the "Product" line instead of "Product type".

Thanks 🙂

[Elie_HUCHET]

Thank you!!

[Vijay_A_Verma · Accepted solution]

Best way is that wherever Product Type is mentioned, change that to Product.

If you don't want to do above, insert the below statement after the source statement

(Right click on Source in Applied Steps pane, Insert Step After and paste the below in formula bar)

Table.RenameColumns(Source,{"Product","Product Type"})