Skip to main content

Power BI

Needs Votes

Query Folding Improvements

Vote (28) Share
Alex Powers's profile image

Alex Powers on 03 Jun 2020 23:32:57

Based on the community's findings we'd welcome a second look at the following Power Query functions vs the equivalent SQL server functionality for improvements to Query Folding.

These changes would enable faster dataset refreshes where applicable and improve the overall experience of using Power Query against relational data sources.

Name----------------------------------Supports Folding--------SQL
Character.FromNumber------------FALSE---------------------CHAR
Text.PositionOf------------------------FALSE--------------------CHARINDEX
Date.AddDays-------------------------FALSE---------------------DATEADD
Date.AddQuarters--------------------FALSE---------------------DATEADD
Date.AddWeeks-----------------------FALSE---------------------DATEADD
Date.DayOfWeekName-------------FALSE---------------------DATENAME
Date.EndOfMonth--------------------FALSE---------------------EOMONTH
Text.At-----------------------------------FALSE---------------------SUBSTRING
Text.Start-------------------------------FALSE---------------------LEFT
Text.Replace--------------------------FALSE---------------------REPLACE
Text.Repeat----------------------------FALSE---------------------REPLICATE
Text.Reverse--------------------------FALSE---------------------REVERSE
Text.End--------------------------------FALSE---------------------RIGHT
Text.ReplaceRange-----------------FALSE---------------------STUFF
Text.Range----------------------------FALSE---------------------SUBSTRING

Comments (3)
Alex Powers's profile image Profile Picture

Alan Artenstein on 16 Jan 2025 20:09:06

RE: Query Folding Improvements

sorry.. upper is foldable just not within Table.TransformColumns.. makes sense.

Alex Powers's profile image Profile Picture

Alan Artenstein on 16 Jan 2025 20:05:00

RE: Query Folding Improvements

We noticed today during a demo that the upper and string_split in sql server were non-foldable.

Alex Powers's profile image Profile Picture

Jerry Knowles on 17 Oct 2022 18:25:15

RE: Query Folding Improvements

and fold for Teradata, and other databases too, please. How does Microsoft not fold these? Substring commands are one of the most basic SQL statements :-(