Forum Discussion

ldwf's avatar
ldwf
Icon for Helper V rankHelper V
15 days ago
Solved

Report Builder - Pass parameter values to semantic model

I have a Report Builder/Paginated Report that connects to a published semantic model which points to a SQL Server database.  The report prompts the user to enter in various parameter values (like fro...
Need Help
  • Cookistador's avatar
    Cookistador
    14 days ago

    I think I did not understand your need
    Can you try the following steps (even in import mode, it should work)

    1. Right click on the dataset for which you want to add some filters and select Dataset Propreties
      You should have something like:
      EVALUATE
      SUMMARIZECOLUMNS(ColumnName...)

      And replace it by the following code snippet
      DEFINE
      VAR param1 = @ParamName (Name of the first parameter you want to test)

      EVALUATE
      FILTER( TableName, TableName['ColumnToFilter'] = param1)

    2. Link your parameter to the query, right click on your dataset --> Dataset propreties -->Parameters

      and here pass the name of your parameter

    3. Run your query, normally it will ask to pass paramter BEFORE to generate the report
Cookistador's avatar
Cookistador
Icon for Super User rankSuper User
14 days ago

I think I did not understand your need
Can you try the following steps (even in import mode, it should work)

  1. Right click on the dataset for which you want to add some filters and select Dataset Propreties
    You should have something like:
    EVALUATE
    SUMMARIZECOLUMNS(ColumnName...)

    And replace it by the following code snippet
    DEFINE
    VAR param1 = @ParamName (Name of the first parameter you want to test)

    EVALUATE
    FILTER( TableName, TableName['ColumnToFilter'] = param1)

  2. Link your parameter to the query, right click on your dataset --> Dataset propreties -->Parameters

    and here pass the name of your parameter

  3. Run your query, normally it will ask to pass paramter BEFORE to generate the report