Table.FromList error "We couldn't convert the value ???? to type Text."

[trt18-sistemas]

Hi there,

I'm trying to create a tabel from a list. The list was created from two values (dates converted into number), but when I try to create the table I get a error. More details bellow:

Power Query Script where the error is launched:

let
    #"Cria Lista Datas" = {Number.From(PARAM_MIN_DATA_OCORRENCIA) .. Number.From(Date.From(DateTime.LocalNow()))},
    #"Cria tabela da lista" = Table.FromList(#"Cria Lista Datas")
in
    #"Cria tabela da lista"

PARAM_MIN_DATA_OCORRENCIA is a Date value calculated in another Query. It's working fine, but if you wish it an be replaced by "01/10/2012" and the error will be lauched any way.

Could any one say if I'm doing something wrong or if it's Power Query bug?

[latimeria · Accepted solution]

Hi @trt18-sistemas ,

By default items in the list are separated by comma.

Try this:

Table.FromList(#"Cria Lista Datas", Splitter.SplitByNothing())