cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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.

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.

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
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 127 members 1,676 guests
Please welcome our newest community members: