Forum Discussion

ok_kpop's avatar
ok_kpop
Frequent Visitor
3 years ago
Solved

Power Query Editor - Change in Column Name Not Importing

I have 4 columns of data from Excel loaded into Power BI. Is it possible to have it where if the column is named either "Day" or "day" in Excel that it'll still get loaded in correctly? It seems the ...
Need Help
  • parry2k's avatar
    parry2k
    3 years ago

    ok_kpop after the promoted headers step, add Table.TransformColumnTypes steps (before changed type step)

     

     

    let
    Source = Excel.Workbook(File.Contents("\\My Documents\test2.xlsx"), null, true),
    Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],
    #"Promoted Headers" = Table.PromoteHeaders(Sheet1_Sheet, [PromoteAllScalars=true]),
    #"Fix Column Names"= Table.TransformColumnNames(#"Promoted Headers", Text.Proper),
    #"Changed Type" = Table.TransformColumnTypes(#"Fix Column Names",{{"Time", Int64.Type}, {"Day", Int64.Type}, {"A", Int64.Type}, {"B", Int64.Type}}
)
in
    #"Changed Type"

     

     

parry2k's avatar
parry2k
Super User
3 years ago

ok_kpop after the promoted headers step, add Table.TransformColumnTypes steps (before changed type step)

 

 

let
    Source = Excel.Workbook(File.Contents("\\My Documents\test2.xlsx"), null, true),
    Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],
    #"Promoted Headers" = Table.PromoteHeaders(Sheet1_Sheet, [PromoteAllScalars=true]),
    #"Fix Column Names"= Table.TransformColumnNames(#"Promoted Headers", Text.Proper),
    #"Changed Type" = Table.TransformColumnTypes(#"Fix Column Names",{{"Time", Int64.Type}, {"Day", Int64.Type}, {"A", Int64.Type}, {"B", Int64.Type}}
)
in
    #"Changed Type"