report builder passing parameter

Hi mp390988 
Thanks for reaching out to the Microsoft fabric community forum.


Please verify weather the Data type for the parameter is correct

To do that, you could right click on parameter and then on parameter properties

Additionally, test the query in MySQL with parameter values, copy your dataset query into MySQL Workbench, then replace @FromCalendarDate and @ToCalendarDate with the exact values captured from the report’s text box output. Run the query to confirm it returns rows; if it doesn’t, check for possible issues such as incorrect date formatting, missing single quotes around date values, or mismatches caused by any SQL command.

I hope this information helps. Please do let us know if you have any further queries.
Thank you