Erro power query

[Viniciussouza]

Ao clicar em transformar dados identifiquei que existe uma mensagem de erro "Erros na Consulta - 22/11/2023 06:16:58" informando que o erro estaria na base de dados PRODUTIVOS "Erros em PRODUTIVO". Pequisando em alguns foruns verifiquei que o erro deveria está com a identificação vermelha na consulta, porém não consigo localizar a identificação do erro. 

[Anonymous · Accepted solution]

Hi @Viniciussouza 

The "Error in Query" message indicates that there is a problem with the data or query step you are trying to transform. Try the following to troubleshoot errors:

Check for any red text or error icons in the Data Preview column.

In the Applied steps pane, look for any error indicators next to the step name.
Click step by step to determine in which step the error occurred.

Click Advanced Editor to view the M-code for the query. Review the code to identify potential sources of error.

Consider using an error handler such as "Try... otherwise" to catch and manage errors.

In some cases, checking the error log can give you more details. This can be done in the Diagnostic Tools tab of Power BI Desktop.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.