Error when Passing parameter for date field

[POSPOS]

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:


I get an errror as below when I use the code.

Can someone please suggest on how to fix this?

Thank you.

[lbendlin]

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]

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

[lbendlin]

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

- if it is not, encase it in curly brackets

[POSPOS]

@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

[lbendlin]

Maybe post a less obfuscated version of your query?

[POSPOS]

@lbendlin  : I was now able to pass one parameter that I created.

When I pass the second parameter "DatePar1", I get an error.

Error:


Can you please suggest.

[lbendlin]

what happens when you use

{ DatePar, DatePar1 }

[POSPOS]

@lbendlin  - changed the code as below.

Error:

[lbendlin]

What date format is your BW expecting? ISO8601?

[POSPOS]

@lbendlin  - This is the date format which works in BW.

Even in Power BI , the format is same:

[lbendlin]

these are not the same formats.  (and neither are good formats).  Can you specify the date in ISO8601?

[POSPOS]

@lbendlin  : changed the format :

I get the below error:

[lbendlin]

That's a datetime.  You need to convert to datetime first and then to date.

But I am disappointed that SAP BW can't handle this natively.

[POSPOS]

@lbendlin  - I get the same issue as previously mentioned with date type as well.