Erro in power Query Data.value

Looks like one of your date columns has non-date values in it.  You have a couple of options

- change the column type to text

- choose to replace or remove errors

- cleanup your data so the issue doesn't appear again

Your sample data seems to be shifted and has weird characters likely due to encoding problems.   Can you post it as a file?

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Hi andreoliveir 

This error usually occurs when some values cannot be parsed to date type successfully. This error probably doesn't occur on a transformation step in Power Query but on some rows in a column which is expected to have date-type values, so you don't see an error breaking the whole query in Power Query.  

To deal with it, check all date-type columns in your table. Whether they have any error values. If any, please correct the errors. Here are some examples that can cause this error and the possible solutions for dealing with it:

• The source "Date" data is in text type with format "dd/mm/yyyy". While in Power Query it expects "mm/dd/yyyy" for date value (this is based on your service setting). So when you change this column to date type in Power Query, using Locale when changing the type. 
• The Date column has some special letters that represent blank, e.g. "-", "N/A" that cannot be changed to date type. You can replace them with null or empty string "" first, then change the column to date. 
• If you are connecting to a folder which have multiple files, check the data of each file to ensure their data type is consistent. 

Here are some similar threads for this error that may be helpful:

DataFormat.Error: We couldn't parse the input prov... - Microsoft Fabric Community

Data Format Error: We couldn't parse the input provided as a Date value - Microsoft Community Hub

Power BI Error - Correcting the error: We couldn't parse the input provided as a Date value.

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

thank you, I will do the testes here.