Forum Discussion

trt18-sistemas's avatar
trt18-sistemas
Icon for Advocate IV rankAdvocate IV
3 years ago
Solved

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

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?

  • Hi trt18-sistemas ,

    By default items in the list are separated by comma.

    Try this:

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

1 Reply

  • latimeria's avatar
    latimeria
    Icon for Solution Specialist rankSolution Specialist

    Hi trt18-sistemas ,

    By default items in the list are separated by comma.

    Try this:

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