Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
trt18-sistemas
Advocate III
Advocate III

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 Specialist
Solution Specialist

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 Specialist
Solution Specialist

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors