Query key date variables not working for SAP BW

[sejlersen]

Hello,

When trying to import data from SAP BW query using a query key date variable then it is not possible to enter the right value in the prompt making it impossible to use the query. 

If I use a date then it throws a MDX error.

Hope someone can help.

Thanks

Søren

[v-yuta-msft]

@sejlersen ,

Have you using the correct searching format? I woud suggest you search this error in SAP support site firstly as the error message mentioned.

Regards,

Jimmy Tao

[sejlersen]

@v-yuta-msft 

Thanks for the reply. The Power BI prompt will not accept the right format. It says it is not a date. And if I enter a date then I get the MDX error. I tested the format using MDXTEST in SAP BW and here it works fine.

Br

Søren

[v-yuta-msft]

@sejlersen ,

I would suggest you create a support ticket here.

Regards,

Jimmy Tao

[v-yuta-msft]

@sejlersen ,

You can create the support ticket from link below:

https://powerbi.microsoft.com/en-us/support/

Regards,

Jimmy Tao

[sejlersen]

Thanks @v-yuta-msft . Already raised a ticket. Found a work around by using custom MDX, where I can construct the MDX statement with the correct format for the variable.