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
Sparklines: customizable data point limit (allow more than 52 points)
Sparklines in table and matrix visuals currently display up to 52 data points per sparkline. We'd like to suggest a customizable data point limit, so report authors can allow more than 52 points and ...v-kkalvala5 minutes agoMicrosoft EmployeeNew2Views2likes0CommentsAllow dynamic headers for Calculation Groups
calculation Groups reduce duplicated DAX, but their Calculation Item names become static Matrix headers such as Current, MTD, QTD, and YTD. These headers do not tell report consumers which measure i...danieleloFabric2 hours agoNew MemberNew7Views1like0CommentsCentralized retention policies for imported data in Power BI semantic models
Summary Please provide a tenant-level retention policy that allows administrators to centrally enforce automatic deletion of expired data from Power BI Import semantic models, independently of data ...JINHOYOO3 hours agoMicrosoft EmployeeNew59Views19likes1CommentResizable Personalize visual pane or wrapped field names
Problem: The Personalize Visual pane width is fixed and long measure/column names are cropped making it difficult for users to identify which item to add to their visual. Idea: Allo...Simon_AUS9 hours agoRegular VisitorNew42Views8likes0Comments