Forum Discussion
Problem with query folding when incrementally refreshing on Azure SQL database table
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?
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.
2 Replies
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.