topic Re: Prefilter Databricks records in Powerbi with dates from SQL Server in Developer https://community.fabric.microsoft.com/t5/Developer/Prefilter-Databricks-records-in-Powerbi-with-dates-from-SQL/m-p/4171741#M55634 <P>If you want to fight the firewall dragon, sure.&nbsp; Beware, that dragon is rather irritable, especially when cross source data leakage is involved.</P> <P>&nbsp;</P> <P><A href="https://learn.microsoft.com/en-us/power-query/data-privacy-firewall" target="_blank">Behind the scenes of the Data Privacy Firewall - Power Query | Microsoft Learn</A></P> Tue, 24 Sep 2024 22:16:22 GMT lbendlin 2024-09-24T22:16:22Z Prefilter Databricks records in Powerbi with dates from SQL Server https://community.fabric.microsoft.com/t5/Developer/Prefilter-Databricks-records-in-Powerbi-with-dates-from-SQL/m-p/4171494#M55624 <P>Hi,</P><P>&nbsp;</P><P>Below is the Requirement:</P><P>&nbsp;</P><P>1) Databricks : Resides Claims data.</P><P>2) SQL Server : Resides Date of Attribution.</P><P>&nbsp;</P><P>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:</P><P>&nbsp;</P><P>The user selects 20240701 in PowerBI. Only records between 20230601 and 20240731 are extracted from databricks into powerBI.</P><P>&nbsp;</P><P>Can the above situation be done?</P><P>&nbsp;</P><P>Thanks</P> Tue, 24 Sep 2024 19:47:01 GMT https://community.fabric.microsoft.com/t5/Developer/Prefilter-Databricks-records-in-Powerbi-with-dates-from-SQL/m-p/4171494#M55624 Anonymous 2024-09-24T19:47:01Z Re: Prefilter Databricks records in Powerbi with dates from SQL Server https://community.fabric.microsoft.com/t5/Developer/Prefilter-Databricks-records-in-Powerbi-with-dates-from-SQL/m-p/4171741#M55634 <P>If you want to fight the firewall dragon, sure.&nbsp; Beware, that dragon is rather irritable, especially when cross source data leakage is involved.</P> <P>&nbsp;</P> <P><A href="https://learn.microsoft.com/en-us/power-query/data-privacy-firewall" target="_blank">Behind the scenes of the Data Privacy Firewall - Power Query | Microsoft Learn</A></P> Tue, 24 Sep 2024 22:16:22 GMT https://community.fabric.microsoft.com/t5/Developer/Prefilter-Databricks-records-in-Powerbi-with-dates-from-SQL/m-p/4171741#M55634 lbendlin 2024-09-24T22:16:22Z