Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I have a parameter of type list that can be null. Here is the code-
(a as list)=>
let
b = if a is null then {""} else a
in
b
And I am invoking the above function like this-
let
Source = Query1(null)
in
Source
The error I get if I run the above query-
Expression.Error: We cannot convert the value null to type List.
Details:
Value=
Type=[Type]
Can someone please tell me how I can pass null to a parameter of type list.
Thanks
Vivek
@vivekjvs
Your function expects list as input that's why the error comes up. Provide the value as follows
let
Source = Query1({null})
in
Source
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.