Enable Regex to increase the power of powerquery. Some function such as split column and extract are good but could be great if custom regex could be used to pattern match more effectively.
VEGA_Y_J_CHEN
1 year agoNew Member
Strongly support on this initiative! PowerQuery is the most suitable tookit from PowerPlatform while considering some needs of text extraction in Regex way. This proposal is aligned with design of Making ETL(Extract/ Transform / Load) within PowerQuery. What's more, I think it can be a puzzle to complete the Product roadmap while Power Platform building more advanced features vs. competitors.
Recent ideas
Support external tables for parquet/csv in Fabric DW
Fabric Data Warehouse allows reading Parquet and CSV files using the OPENROWSET function. However, it does not support external tables that reference Parquet or CSV files (CREATE EXTERNAL TABLE (Tran...jovanpop-msft5 hours agoMicrosoft EmployeePlanned2.9KViews38likes3CommentsFabric warehouse SQL editor: improve Ctrl-Enter
Today the Fabric warehouse SQL editor executes the full text in the editor when you press Ctrl-Enter without anything selected. It would be very convenient if Ctrl-enter only executed the single sql...stegus645 hours agoNew MemberNew22Views0likes1Comment