Dashboard - load issue (default parameter value)
Hi, All -
I’ve developed a dashboard that includes a text box, parameter components, and other elements. Users can input a date and click a trigger button to fetch the data, using inbound parameters in the data adapter.
The dashboard is supposed to default to a date value upon loading, but it’s not pulling the expected default from the parameter.
Ideally, the dashboard should open without any issues, but instead, it’s throwing the following SQL error:
"Conversion failed when converting date and/or time from character string. (SQL Error Number -2146232060, 241)"
Currently, the dashboard is not opening and displays the error above.
The data adapter field value format for date is as shown below.
I’ve tried various options for setting the default value in the dashboard parameter, but the issue persists.
Please let me know if you have any suggestions. thank you !