Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Query key date variables not working for SAP BW

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. 

2020-01-31 06_07_06-Navigator.png

 

 

 

 

 

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

2020-01-31 06_08_41-Navigator.png

 

 

 

 

 

 

 

 

 

 

Hope someone can help.

 

Thanks

Søren

Status: New
Comments
v-yuta-msft
Community Support

@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
Regular Visitor

@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
Community Support

@sejlersen ,

 

I would suggest you create a support ticket here.

 

Regards,

Jimmy Tao

v-yuta-msft
Community Support

@sejlersen ,

 

You can create the support ticket from link below:

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

 

Regards,

Jimmy Tao

sejlersen
Regular Visitor

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.