Erro in power Query Data.value

[andreoliveir]

Olá, meu nome é Andre Barony, im preciso de ajuda por favor.
Eu sou do Brasil e não falo inglês.
Estou precisando de sua ajuda com um erro que encontrei e não consigo resolvê-lo, então estou pedindo essa ajuda de você.
Meu fluxo de dados não está atualizando, baixei o erro e tentei lê-lo, mas infelizmente não encontrei o erro. Eu acesso o power query e para mim não há erro.



Requested on,Nome do fluxo de dados,Status de atualização de fluxo de dados,Nome da tabela,Nome da partição,Atualizar o status,Hora de inÃcio,Hora de término,Duração,Linhas processadas,Bytes processados (KB),Confirmação máxima (KB),Tempo do Processador,Tempo de espera,Mecanismo de computação, Erro,2024-03-04

13:52:04,Açoes,Falhou,Reunião diaria,N/D,Falhou,2024-03-04 13:52:04,2024-03-04 13:52:10,00:00:06.3300,N/D,N/D,N/D,N/D,N/D,Erro: A operação atual foi cancelada porque uma ou mais operações falharam.. ID do pedido: 63fa9a3a-845c-0873-c30a-dd94709af57d.


2024-03-04 13:52:04,Açoes,Falhou,AçÃμes,N/D,Falhou,2024-03-04 13:52:04,2024-03-04 13:52:09,00:00:05.3600,N/D,N/D,N/D,N/D,N/D,Erro: DataFormat.Error: Não foi possível analisar a entrada fornecida como um valor de Data. <ccon> </ccon>. RootActivityId = 6693cb5d-942a-4827-bb7f-e1532801de1a. Param1 = DataFormat.Error: Não foi possível analisar a entrada fornecida como um valor de Data. <ccon> </ccon> ID do pedido: 63fa9a3a-845c-0873-c30a-dd94709af57d.

[andreoliveir]

thank you, I will do the testes here. 

[Anonymous]

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!

[lbendlin]

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-...

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/1447...