Forum Discussion

angelorauber's avatar
angelorauber
New Member
1 year ago
Solved

Convertion Value error on Text.Combine function

Olá,        Estou preparando uma consulta com parâmetro de entrada de tabela do Excel para o Power Query. Criei a coluna customizada concatenando os dados. Porém quando vou usar a função Text.Combi...
  • lbendlin's avatar
    1 year ago

    and f.numemp in (" & Text.Combine([Empresa],",") & ")

     

    between '01/01/1900 00:00:00' and '31/12/2500 23:59:59'

    Please don't do that.  Use realistic dates, or leave them blank.  You are adding millions of rows of data to your data model for no reason.