cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mholsen Member
Member

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.Query folding.PNG

 

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.CreationTime column.PNG

 

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

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

@Mholsen ,

 

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.

Query-folding.jpg 

 

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.

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

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

@Mholsen ,

 

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.

Query-folding.jpg 

 

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.

View solution in original post

Highlighted
Mholsen Member
Member

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

Thanks for the reply.

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

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors