Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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
B. DataSet Properties (Parameters)
Please let me know if I can provide any more information
Did you mean to post this in the PBIRS section?
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.