Erro in power Query Data.value

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!