Forum Discussion

Elie_HUCHET's avatar
Elie_HUCHET
Helper III
4 years ago
Solved

Data export problem, rename column

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 🙂

Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    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"})

     

2 Replies

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Most Valuable Professional
    4 years ago

    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"})