Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
AsNa_92
Resolver II
Resolver II

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:

AsNa_92_0-1724226681970.png

 

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:

AsNa_92_1-1724226839043.png

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:

AsNa_92_2-1724227012207.png

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) ?

AsNa_92_3-1724227100393.png

Because (Allow Blank Value) is only for text data type.

4 REPLIES 4
AsNa_92
Resolver II
Resolver II

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:

AsNa_92_0-1724232796799.png

 

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.


--
Riccardo Perico
BI Architect @ Lucient Italia | Microsoft MVP

Blog | GitHub

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

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.

R1k91
Super User
Super User

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


--
Riccardo Perico
BI Architect @ Lucient Italia | Microsoft MVP

Blog | GitHub

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

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.