Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Pass Report Builder Parameters to Semantic Model Query Parameters

Hello!

I am attempting to create a semantic model that has several smaller tables querying a bigger table all within the semantic model. I have parameters I am passing to the smaller tables through their query to only bring in the data from the main tables with those specific parameter options. 

 

What I'm curious is about if anyone has tried or can think to try passing the parameters in Report Builder from the user selection to the semantic models parameters. Essentially I'd like the parameters a user selects at the report level to connect to the parameter set up on the semantic models smaller tables. 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

    You can manually link query parameters to renamed report parameters.

    First, in the Report Data pane, right-click the dataset, click Dataset Properties, and then click Parameters.
    Then, in the Parameter Name column, find the name of the query parameter. The system automatically populates the parameter name based on the query. Each time you change the query, the query is checked for new query parameters. When the query changes, the query parameters you created manually do not change!

    Below is the official link will help you:
    Associate a Query Parameter with a Report Parameter (Report Builder) - SQL Server Reporting Services (SSRS) | Microsoft Learn

    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.