// Rows that fail a plain type change // Pack: Fridge sensor log (Power Query Exercises, https://powerqueryexercises.com/downloads/sensor-log-errors) // // Source bindings // In the Power Query Exercises simulator each name below is bound directly to a pack file. In Excel or // Power BI Desktop the first steps of this query do that binding instead: // SensorLog the pack file sensor-log.csv -> File.Contents(PackFolder & "sensor-log.csv") // Set PackFolder to the folder where you extracted the pack (keep the trailing backslash). // // Validated in the Power Query Exercises simulator (engine 0.1.0) against this pack's files; it returns // 2 rows with columns Timestamp, Sensor, Reading. // It has not been run in Excel or Power BI by us. This is query text, not a ready-to-refresh workbook. // Independent practice material; not affiliated with or endorsed by Microsoft. let PackFolder = "C:\PQE\sensor-log-errors\", SensorLog = File.Contents(PackFolder & "sensor-log.csv"), Source = Table.PromoteHeaders(Csv.Document(SensorLog, [Delimiter=",", Encoding=65001, QuoteStyle=QuoteStyle.Csv]), [PromoteAllScalars=true]), #"Changed Type" = Table.TransformColumnTypes(Source, {{"Reading", type number}}, "en-US"), #"Errors only" = Table.SelectRowsWithErrors(#"Changed Type", {"Reading"}) in #"Errors only"