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

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
Community Support

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
Community Support

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 Advocate II
Advocate II

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
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors