Invalid MDX identifier issue while connecting to SAPBW with DateKey

[sbandaru]

Hi all,

I am facing a MDX identifier issue while trying to access SAP BW cube which has key date value as mandatory parameter. I've tried with all possible date formats like MMDDYYYY,mm/dd/yyyy,mm-dd-yyyy,mm.dd.yyyy, yyyy/mm/dd etc., but couldnt resolve this issue. In a confusion whether it is power bi compatibility issue or SAPBW issue. This cube works fine with BEx analyser in Excel. As there is no date picker in powerbi i am not able to understand which date format should be used for sapbw key parameter. Kindly help me with this one.  

Thanks & Regards,

Sudheer B.

[Anonymous · Accepted solution]

Hi

I had a similar issue and I used [<Bex Query variable input>] and it worked. Please try this e.g [12/12/2016]

[nikil]

Adding square brackets around the value worked for me as well.