Gcobani Mkontwana

Gcobani Mkontwana

  • 557
  • 1.9k
  • 404.8k

We couldn’t parse the input provided as a Time value

Oct 22 2019 5:09 AM
Hi Team
 
I have this query on powerbi and want to query to accept one column as time data type not as Date/Time/TimeZone of a specific region and errror is as followed;
 
Expression.Error: We couldn't parse the input provided as a Time value.
Details:
2019-10-22T07:46:44.2270000Z
 
let = Json.Document(File.Contents("C:\Users\Gcobanim\Documents\TestJson\Azure JSON files\TestJ\MKR1010-PowerBIVisualizationInput (1).json"))
# "Converted Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"temperature", "illuminance", "EventEnqueuedUtcTime"}, {"Column1.temperature", "Column1.illuminance", "Column1.EventEnqueuedUtcTime"}),
#"Change Type"= Table.TransformColumnTypes(#"Expanded Column1",{{"Column1.EventEnqueuedUtcTime", type time}}),
#"Change Type" = #"Changed Type"{1}[Column1.EventEnqueuedUtcTime]
 
How can i improve that type to able to change it to time as a data type?

Answers (1)