Parameter in the initial SSAS MDX query

Question

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.

amitchandak · Answer

Anonymous , are you looking for something suggested in this idea -https://ideas.powerbi.com/ideas/idea/?ideaid=c892fe7f-e327-466b-8bd9-0ba8b6362439
&nbsp;
Also, check this past discussion on DAX -https://community.powerbi.com/t5/Desktop/limit-SSAS-data-import-through-MDX-DAX-query/m-p/700566

farhanahmed · Answer

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

anonymous · Answer

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.

Forum Discussion

Parameter in the initial SSAS MDX query

3 Replies

Related content

SQL initialization error

query parameter

Facing one issue while binding M Query parameter in Slicer

Dynamic M query parameter binding to a query table which uses import mode

Pass Parameters to SQL Queries