Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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:
and by default for the parameters, it selected available Values to Get value from query but when I run it, it shows as dropdown and I don't want that, I want as textbox .. so after I search it says select default values instead of available values:
However, when I run it shows other parameters Grey, and I must fill the first one then click on view report so I can fill the next parameter:
How can I avoid that and let the user fill all parameters at once?
Also, is there possible way to let the integer parameter to be blank (not required to be filled) ?
Because (Allow Blank Value) is only for text data type.
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:
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.
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.
I'm not sure I got the first request. Why don't you simply put both available values and default values to "no default values" and "no available values"? this makes parameter "a simple textbox".
for the second request, "blank" is a "string only concept". in paginated report only a string can be blank.
an integer/deciaml can be 0, <>0 or NULL
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
User | Count |
---|---|
7 | |
6 | |
3 | |
3 | |
2 |