Parameters on bex query not working

[AOD]

Hi all, 

I have created parameter in PowerBI for Fiscal year as type text and given current value as '2022'.

Also same paramter is added in power query

{Cube.ApplyParameter, "[!V000017]", {#"Fiscal year"}},

However I have below error -->

Expression.Error: We cannot convert the value 2022 to type List.
Details:
Value=2022
Type=[Type]

Kindly help. 

Thanks.

[v-angzheng-msft · Accepted solution]

Hi, @AOD 

Try this code to convert text to list:

Table.ToList(Table.FromValue(Text.From(text)))

Result:

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.