This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 72%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERJ%3C/text%3E%3C/svg%3E)
Good morning,
I am developing a solution in excel through the power query where I source the analysis service.
And I am trying to optimize the solution where I intend to apply the parameter.
For that I am using the following instruction:
{Cube.ApplyParameter, {"ColumnNameYear"}, {"2021"}}
But it is giving the following error:
"Expression.Error: It is not possible to convert a value of type List to type Function."
What is the correct way to apply a parameter?
Thanks in advance for the answer
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 34%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYL%3C/text%3E%3C/svg%3E)
Hi, I have quite similar situation here.
I got 'no more memory' error when loading data from SAP BW into Power query in Power BI, however there's no other predefined filter I can apply. I applied extra filters in the next steps (from advanced editor), only to keep one single row, but I still get the same error. The filters applied after the SAP query doesn't seem to be applied when querying dataset from SAP, though it shows the 'cube icon' in both steps.. @Dima P @Darren Gosbell . Really need to find a way to incorporate the filter into the cube query step somehow.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 47%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDG%3C/text%3E%3C/svg%3E)
I don't have access to a SAP BW instance where I could test the query folding. But if the out of memory error is coming from the machine running Power Query then it may not be able to fold in the filters you are applying and the only work around I can think of is to had write the query with the filter you want.
However it's also possible that the filters are being folded correctly and that you have hit an issue in SAP BW where it is running out of memory itself trying to process the query.
So you really need to figure out where the out of memory error is coming from in order to figure out a work around.