Forum Discussion

Jdokken's avatar
Jdokken
Helper III
5 years ago

Adding a Parameter to a Dax Query from Performance Analyzer in Report Builder

Hello-  I am using the query created in the Performance Analyzer in Power Bi but having a difficult time modifing the query to include a date (Text Field) report parameter.  Currently the query has ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Jdokken ,

 

Please kindly refer to the document: Report parameters in Power BI Report Builder.

This topic describes the common uses for Power BI Report Builder report parameters, the properties you can set, and much more. Report parameters enable you to control report data, connect related reports together, and vary report presentation. You can use report parameters in paginated reports you create in Report Builder.

 

Best Regards,

Stephen Tao

 

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

  • Jdokken's avatar
    Jdokken
    Helper III
    5 years ago

    It states that the Parameter is not Declared when I try adding the parameter into the Query Designer. 

     

     

      • Jdokken's avatar
        Jdokken
        Helper III
        5 years ago

        Thanks, I tried adding the Parameter in the Parameters Toolbar button in the Query Designer window. Once I do that and then try to add it in the Query (which I'm not sure if I'm doing it correctly) gives me a message of "Query Preparation failed". I Tried using, 

        TREATAS({@YearMonth}, 'Period'[Year Month])  but that gave me the same message.