Forum Discussion

AsNa_92's avatar
AsNa_92
Icon for Resolver II rankResolver II
2 years ago

Issue parameters in report builder from PBI semantic model

Hi, I'm connecting my dateset from a sematic model published in PBI workspace, I have set the dataset in report builder using Query Design (DAX) and set the parameters as well as below:   an...
"Report Builder"
'Need help'
AsNa_92's avatar
AsNa_92
Icon for Resolver II rankResolver II
2 years ago

If I select "no default values" for both defaulf and available and I select (allow Null value) for both Start and End At since there are null values, the output doesn't come:

 

  • R1k91's avatar
    R1k91
    Icon for Super User rankSuper User
    2 years ago

    have you some cases where both start and end date have values? 

    I would try that case before and then try to use NULLs.

    if you see data for evaluated start and end you know that parametrization is working and the only issue is when you pass NULLs.


    I recall a project where it was difficult to correctly parse NULLs from paginated to the undelying semantic models.

    • AsNa_92's avatar
      AsNa_92
      Icon for Resolver II rankResolver II
      2 years ago

      Yes it's working if I put a dates, but if I want the user to enter only one value example the ID and the rest not required, how can I do that? 

       

      Also if I make the name allowing blank and run the report without entering a value for the name it doesn't work.