https://community.fabric.microsoft.com/t5/Developer/Incremental-Data-Load-for-future-dates/m-p/3182883#M42153 <P><A href="https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-xmla#override-incremental-refresh-behavior" target="_blank">Advanced incremental refresh and real-time data with the XMLA endpoint in Power BI - Power BI | Microsoft Learn</A></P> <P>Read the "effectivedate"&nbsp; part.</P> Wed, 12 Apr 2023 01:41:10 GMT lbendlin 2023-04-12T01:41:10Z https://community.fabric.microsoft.com/t5/Developer/Incremental-Data-Load-for-future-dates/m-p/3179758#M42125 <P>Hi,</P><P>I am working on huge dataset its record count is around 200 million records and I am trying to implement incremental load. While applying policy I can see it is available to load the data till todays date or till the month end but as our data is travel data like on which date someone want to travel according to there booking date so we need to include the future date. I already made partitions based on quarter basis and last 3 month data on month basis and load the data but issue occurs now how to incorporate the future dates as effective date concept is also not working.&nbsp;</P> Mon, 10 Apr 2023 11:13:23 GMT https://community.fabric.microsoft.com/t5/Developer/Incremental-Data-Load-for-future-dates/m-p/3179758#M42125 rajatkatiyar 2023-04-10T11:13:23Z https://community.fabric.microsoft.com/t5/Developer/Incremental-Data-Load-for-future-dates/m-p/3182883#M42153 <P><A href="https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-xmla#override-incremental-refresh-behavior" target="_blank">Advanced incremental refresh and real-time data with the XMLA endpoint in Power BI - Power BI | Microsoft Learn</A></P> <P>Read the "effectivedate"&nbsp; part.</P> Wed, 12 Apr 2023 01:41:10 GMT https://community.fabric.microsoft.com/t5/Developer/Incremental-Data-Load-for-future-dates/m-p/3182883#M42153 lbendlin 2023-04-12T01:41:10Z