Parameter in the initial SSAS MDX query

[Anonymous]

I need to pass a parameter to the very initial MDX query. I need it there because if I load all the data PBI crashes due to memory consumption. Therefore I need it from the very beginning. Is it possible to pass it like this? Please check the screen shot below.

[FarhanAhmed]

Why aren't you using Live Connection instead of Import method ?

[Anonymous]

We would like to add some extra measures in Power BI without adding them in the cube. As I have seen, it is impossible to create measures in PBI if you choose live connect. That is why we are using the import method.

[amitchandak]

@Anonymous , are you looking for something suggested in this idea -https://ideas.powerbi.com/ideas/idea/?ideaid=c892fe7f-e327-466b-8bd9-0ba8b6362439

Also, check this past discussion on DAX -https://community.powerbi.com/t5/Desktop/limit-SSAS-data-import-through-MDX-DAX-query/m-p/700566