Parameter in SAP BW Query Error

[Anonymous]

Hi,

I'm trying to pass a parameter to a SAP BW query but I keep getting an error that says "The value is not a cube." Below is my query. Much appreciated if someone can help fix this.

let
  Prefix = "[0FISCPER]",
  CuurentPeriod = Text.Combine({"Z6",Param_CurrentPeriod}),
  #"GetParameterValue" = "[" & (CuurentPeriod) & "]",
  Orders = #"Fact Sales Open Orders",
   #"Added items" = Cube.Transform(Orders, 
   {
    {Cube.ApplyParameter, "[!V000001]", {"[0FISCPER]." & #"GetParameterValue"}},
    ....
   })
in
  #"Added items"

[Anonymous · Accepted solution]

I managed to get around the error by creating a fuction to pass the parameter 😃

[vkoppunuru]

This worked for me.

ST is current data in format YYYYMMDD

[vkoppunuru]

Can you share your solution.

It will be very helpful.

[AlexisOlson]

Based on the sources below, the first thing I'd recommend is making sure Power BI is up to date.

https://community.powerbi.com/t5/Desktop/Error-The-value-is-not-a-cube-While-connecting-the-SAP-HANA...

https://windowsreport.com/value-errors-power-bi/