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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
mng
Advocate I
Advocate I

Passing parameters to subreport - missing value error

I am trying to pass ID's to a subreport as they are listed in the main report. It works fine when I run it in the subreport and manually type in the ID into the parameter field but when I run it from the main report, it is giving me a "parameter is missing value" error.

Here is an example of my main report structure generated from an SQL query:

Table Structure:

Table Structure:
| Area |
| -------- |
| ID |
| -------- |
| SubReport|

 

 

Example report output:

*Report generates a list of IDs and is grouped/sorted by the Area

 

Area: Atlanta
 ID#1234
   -Call Subreport for ID#1234 profile
 ID#1235
    -Call Subreport for ID#1235 profile
Area: Boston
 ID#1236
   -Call Subreport for ID#1236 profile

 

Parameter Settings in main report + subreport: (settings are identical)

A. Parameter Settings

  1. It is set to visually hidden
  2. Declared as a text field
  3. Available + default values (not specified)

B. DataSet Properties (Parameters)

  1. Parameter Name :prm_ID
  2. Parameter Value [@prm_ID]

Please let me know if I can provide any more information

1 REPLY 1
lbendlin
Super User
Super User

Did you mean to post this in the PBIRS section?

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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.

Top Solution Authors