Forum Discussion

aetl1's avatar
aetl1
New Member
2 years ago
Solved

Tabular Model Using Field Parameters

Hello,

 

i want to use Field Parameters on Tabular Model .I created a calculated table like this .

 

Param_Table= {
     ("Count of Product", NAMEOF([Count of Product]), 0,"Product",1),
    ("Sum Of Product", NAMEOF([Sum of Product]), 1,"Product",1)
}
 
Then i want to create dynamic table Slicer on Power BI Desktop.
 
is there any workaround solution about this ?
 
Thank you .

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi aetl1 ,

    You can't create parameters in live connection data sources without a local model. However, if you use DirectQuery for Power BI semantic models and Analysis Services, you can add a local model to create field parameters, please try to get data from SSAS with DirectQuery connection mode.

     

    For more details, you could read related document: Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?

    • aetl1's avatar
      aetl1
      New Member
      2 years ago

      Hello ,

      Let me explain . I created a dashboard using excel files as a source  .I used "Field Parameters" in this dashboard for creating dynamic Table with slicer . After completed dashboard i created new Tabular Model Project getting data from DB .Evereything is same (Measures,Column Names,Tables etc.) .So I need to use Field Parameters via  Live Connection Analysis Service.  I recreated all dashboard again from SSAS except Field Parameters part .

       

      Thanks 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi aetl1 ,

    You can't create parameters in live connection data sources without a local model. However, if you use DirectQuery for Power BI semantic models and Analysis Services, you can add a local model to create field parameters, please try to get data from SSAS with DirectQuery connection mode.

     

    For more details, you could read related document: Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.