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),     ("S...
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.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper 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