Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
andreoliveir
New Member

Erro in power Query Data.value

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.

3 REPLIES 3
andreoliveir
New Member

thank you, I will do the testes here. 

 

v-jingzhan-msft
Community Support
Community Support

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
Super User
Super User

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors