Prefilter Databricks records in Powerbi with dates from SQL Server

Hi,

Below is the Requirement:

1) Databricks : Resides Claims data.

2) SQL Server : Resides Date of Attribution.

The requrement is, when a user selects a date in PowerBi, prefiltered records in Databricks are brought into PowerBi for visualization. Below is an example:

The user selects 20240701 in PowerBI. Only records between 20230601 and 20240731 are extracted from databricks into powerBI.

Can the above situation be done?

Thanks