Forum Discussion
Post Partisanreport 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
Super UserHi mp390988
The approach used seems correct.
Steps:
- Set Correct Data Type – Use the Date/Time type for report parameters instead of text.
- Format Dates for MySQL – Map parameters in the dataset with expressions like=Format(Parameters!FromCalendarDate.Value, "yyyy-MM-dd")
to match MySQL’s expected format. - Check Query & Parameter Mapping – Ensure parameter names match in the query and dataset mapping, and use proper syntax (e.g., BETWEEN @FromCalendarDate AND @ToCalendarDate).
- Debug – Display formatted parameter values in the report to verify correctness before passing them to the query.