cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

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?

1 ACCEPTED SOLUTION
latimeria
Solution Supplier
Solution Supplier

Hi @trt18-sistemas ,

By default items in the list are separated by comma.

Try this:

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

View solution in original post

1 REPLY 1
latimeria
Solution Supplier
Solution Supplier

Hi @trt18-sistemas ,

By default items in the list are separated by comma.

Try this:

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

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors