Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
I'm an idiot! I just had to sort my data the same in power bi data viewer as was in the Excel Sort.
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.
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}})
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |