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
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. 

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Jdokken ,

     

    You may try to contact Power BI team for help by creating a support ticket.

    Website: https://powerbi.microsoft.com/en-us/support/

     

     

    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

      Okay, I tried submitting a support ticket.