incremental data load

[kalpana]

From database we are having millions of rows(6months of data).i have to load the last 6 months data monthly once to bi.and i want to refresh the data daily(current month -start to day before yesterday).

Please tell me how it is possible.

[v-yulgu-msft]

Hi @kalpana,

Here is a similar thread for your reference:  Get data for 1 week before depend on TODAY()

Best regards,

Yuliana Gu

[DAX0110 · Accepted solution]

In the Query Editor, you can specify a Date/Time Filter that will load records between the start of month and the day before yesterday.

The M function to calculate start of month is Date.StartOfMonth

And to calculate yesterday's date you need to use a combination of DateTime.LocalNow and Date.AddDays