The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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?
Solved! Go to 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
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
Hello @vsabrandao ,
can you paste a sample data please?
Proud to be a Super User! | |
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
264 | |
120 | |
115 | |
83 | |
70 |