Problem with query folding when incrementally refreshing on Azure SQL database table

[Anonymous]

I have a standard table on an Azure SQL database that I want to turn on incremental refresh on.

The problem is that I keep getting the "query folding" warning, and if I run the incremental refresh anyway it is painfully slow.

The table is just being loaded as is and contains a DateTime column like required in the MS guide.

The only thing I can think of being the cause of the query being non-foldable is the fact that the DateTime column also contains milliseconds.

Does anyone know if the DateTime format strictly has to be 'YYYY-MM-DD-HH-MM-SS' for query folding and therefore incremental refresh to work in Power BI? Maybe there is even a preferred T-SQL DateTime format like 120 etc?

[v-yuta-msft · Accepted solution]

@Anonymous ,

If the PBIX file was authored in a version of Power BI Desktop prior to the February release, the warning will be displayed regardless until a data refresh is performed.

 

Reference:

https://powerbi.microsoft.com/en-us/blog/incremental-refresh-query-folding/

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks for the reply.

The PBIX file is from the July 2019 version of Desktop, so I doubt that is the case...