Prefilter Databricks records in Powerbi with dates from SQL Server

[Anonymous]

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

[lbendlin]

If you want to fight the firewall dragon, sure.  Beware, that dragon is rather irritable, especially when cross source data leakage is involved.

Behind the scenes of the Data Privacy Firewall - Power Query | Microsoft Learn