Forum Discussion

POSPOS's avatar
POSPOS
Icon for Post Partisan rankPost Partisan
2 years ago

Error when Passing parameter for date field

Hi all, I am using SAP BW Bex query as source. I have a date variable in the bex query. I am tying to pass (current date-7) as start date and current data as end date.   Variables in Bex...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Read about Value.Is   and then adjust your Power Query code to account for both scenarios.  Easiest approach is to make a fake list out of a single value and then tailor the Bex query for lists.

  • POSPOS's avatar
    POSPOS
    Icon for Post Partisan rankPost Partisan
    2 years ago

    lbendlin -  could you pls provide steps on how to achieve using the fake list out of a single value you mentioned,

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      2 years ago

      - use Value.Is to check if the parameter is a list

      - if it is not, encase it in curly brackets

      • POSPOS's avatar
        POSPOS
        Icon for Post Partisan rankPost Partisan
        2 years ago

        lbendlin  - I looked at the parameter type in the backend query and it is not a list. I have also enclosed in curly brackets and still get the same error