Expression error and time greater than 23:59:59

[vsabrandao]

Hello guys!
I have a problem in the query editor, it is always returning the same error when I try to merge queries in an 'internal' way (corresponding rows). The error that returns is as follows:

"Expression.Error: We were unable to parse the input provided as a Time value.
Details:
24:53:00"

However, the column that contains this value, and others greater than 23:59:59, was deleted in the previous steps. And even if I keep the column in text format, after trying to follow through with the step that merges the queries, the error comes back up. What can I do to be able to run my query merge successfully?

[Anonymous · Accepted solution]

HI @vsabrandao,

Any update for this? Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to troubleshoot.

How to Get Your Question Answered Quickly  

In addition, you can also add 'Error handling' statements in your M query expression to handle these error parts.

Error handling - Power Query | Microsoft Learn

Regards,

Xiaoxin Sheng

[Idrissshatila]

Hello @vsabrandao ,

can you paste a sample data please?