Dear members,I have a file which contains all the transactions and tickets generated for the last month from our ticketing system. The thing is the column for created time is in text format. Issue happens when i wanted to convert the column to Date. As a result, some fields were successfully converted and some fields have "Error". Please refer the image below After using the first row as headeremove these errors as they will affect my reporting and tracking process. The error message is "DataFormat.Error: We couldn't parse the input provided as a DateTime value". The sample is available here for your reference Sample Data Set.xls

Hey Anonymous , for me it worked without any errors with your data.Can you tell me the error? Otherwise this happens for me once in a while when I import data in another locale format, like US format and I'm in Europe.Try to import as with locale. Important, you have to do that when the column is still in format text.Right click on the column --> Change Type --> Using Locale: Then chose Date/Time and Locale English (US): Afterwards he tries to make a datetime field from the US format.Let me know if that worked.If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍 Best regardsDenis Blog: WhatTheFact.bi

Error when converting text to date with Power BI

Forum Discussion

Related content

Converting SSRS Reports to Power BI

error when converting text to number

Error loading Power BI report

Converting to Percentage

Power BI Service error