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
Get Secret from Azure Key Vault using Fabric Workspace Identity
Users can access key vault secrets using notebookutils.credentials.getSecret. This is based purely on the user's access (or object owner's access, if the notebook is being run in a pipeline). In larg...sean_cochran59 minutes agoResolver INew3.2KViews14likes4CommentsPer-visual Data Freshness Badge with configurable staleness alerts
Problem: Report consumers can’t tell whether the data behind a specific visual is current. Page-level “last refreshed” workarounds ignore that different tables refresh on different schedules, which l...gopinathtk9 hours agoNew MemberNew1View0likes0CommentsNative Master Data Management Solution
Microsoft Fabric currently lacks a native Master Data Management (MDM) capability, creating a gap for organizations that need to manage and govern business-critical reference data such as customers, ...bradcoles10 hours agoRegular VisitorNew313Views1like4CommentsAllow Power BI subscriptions to use a no-reply sender instead of the subscription owner's mailbox
Following the migration to the new email delivery platform, subscription emails now appear to come from the subscription owner. This generates large volumes of Out of Office replies, auto-replies, an...tm8210 hours agoNew MemberNew90Views19likes3Comments