BIP Report Not Filtering Data Based on Dashboard Prompt Date Parameters

Summary:

The BIP report has date parameters for Paygroup Effective Start Date and Effective End Date.
It works correctly when run directly with a date input.
However, when using dashboard prompts (variable or column), the report does not filter data.

In the Data Model:
Parameters are defined with Data Type as Date
The report works as expected when run directly by passing date values (e.g., 03/27/2026), and it correctly fetches the data.

However, when integrating the report with a Dashboard:

• The report is not filtering data based on the selected prompt values in the dashboard
• Created Dashboard Prompts using variable prompts