Data Not Pulling In Properly

[Anonymous]

I'm wondering why my binary indicator column is not properly pulling from Excel. In the query preview isBatchNumber is pulling properly. 

However, after the query executes, it is just full of 0's

[Anonymous · Accepted solution]

I'm an idiot! I just had to sort my data the same in power bi data viewer as was in the Excel Sort.

[Cmcmahan]

Have you done any transformations or filtering on the isBatchNumber column?  If you could provide us with the full set of commands from the Advanced Editor window, I could help more.

[Anonymous]

Thank you for the reply Cmcmahan. The line of my query that is doing this 

#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Order", Int64.Type}, {"Material", Int64.Type}, {"Column3", type any}, {"Batch", Int64.Type}, {"MRP ctrlr", type text}, {"Order Type", type text}, {"Pr.Superv.", Int64.Type}, {"Act. start", type date}, {"Material Batch Number", Int64.Type}, {"isBatchNumber", Int64.Type}})