Forum Discussion

vanessa's avatar
vanessa
Icon for Post Patron rankPost Patron
5 years ago

Create and pass parameters in SSAS tabular model (1400)

Hi,

 

I have a Power BI report that has a live connection to an Analysis Services tabular model.

Since it is a live connection, I am unable to create parameters in Power BI desktop. 

 

I managed to create a parameter using Expressions in the Analysis Services model, but I am not sure how to pass this parameter as part of DAX query for a measure. I tried using "@", but it still doesn't work.

 

 

 

Need Help
Show and Tell

3 Replies

    • vanessa's avatar
      vanessa
      Icon for Post Patron rankPost Patron
      5 years ago

      Thanks nickyvv 

      But my requirement is a bit different.

       

      I am basically duplicating an app for 2 different sets of users.  In one version of the app I want to implement some conditional formatting, whereas there is no conditional formatting in the 2nd app. 

      In order to achieve this , I was considering using parameters to pass the app name and then implement conditional formatting based on that.

      • nickyvv's avatar
        nickyvv
        Icon for Most Valuable Professional rankMost Valuable Professional
        5 years ago

        vanessa,

        ah right, you didn't mention that ğŸ˜ƒ

        You could get the GUID of the app out of the URL, and populate the parameters with that?