TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Guest User
Tech Writer
2.1k
480.9k
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?
Reply
Answers (
1
)
How to convert JSOn file using Power Bi to convert it to CSV
How to filter button with data in powerbi?