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
4 Comments
- jerry_knowlesNew Member
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 :-(
- aartensteinNew Member
We noticed today during a demo that the upper and string_split in sql server were non-foldable.
- aartensteinNew Member
sorry.. upper is foldable just not within Table.TransformColumns.. makes sense.
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Dynamic current-period defaults for separate Year and Month slicers
Scenario The target scenario is a report viewed in Power BI Service, using a DirectQuery semantic model and a dedicated Date dimension. Separate Year and Month slicers are part of the required user ...vvargasv22 hours agoMicrosoft EmployeeNew9Views0likes0Comments