Incremental refresh does not work for table with number as date

[joshua1990]

Hello all,

I have already read in several places that the incremental refresh works without query folding. Is this true?
I have already been able to perform the incremental refresh successfully for a transactional table. From 10min refresh time to 50sec refresh time in PBI service.

Now I would like to introduce the next table based on the incremental refresh. Unfortunately this table has no real date field, but works on basid of JDE Julian Date in format CYYDDD.
As an example: 01.01.2019 = 119001

I have already found a M-function which converts the number into a Date/DateTime format:

Table.AddColumn(#"Filtered Rows", "Custom", each #date(1900+Number.IntegerDivide([JDate], 1000),1,1)+#duration(Number.Mod([JDate], 1000)-1,0,0,0))

Unfortunately, this function results in a query folding break.
Are there any functions for conversion which do not break query folding?
What other recommendations do you have?

With the above approach the refresh time remains constant

[GilbertQ]

Hi @joshua1990 

All that you need to ensure is that the incremental refresh happens before your query folding breaks.

I have a blog post here explaining how I get it to work with any data source: How to configure Incremental Refresh with Power Query in Power BI - Reporting/Analytics Made easy wi...