sven_weber
11 years agoNew Member
Status:
Abandoned
Add regular expression support to as native database feature
NULL
10 Comments
- colinbanfieldNew MemberVery important feature for more complex cleansing and validation
- evans2New MemberPlease include this feature. It would be incredibly useful.
- i_feldmannNew MemberStrongly vote for this feature. There is a demand for it out there. See 3 Posts in Forum within 1 week: 1) https://social.technet.microsoft.com/Forums/en-US/c83672a9-c208-4b29-872e-4032fdec67f3/regular-expressions-in-power-query?forum=powerquery 2) https://social.technet.microsoft.com/Forums/en-US/8f5ae2d5-b801-4c25-be95-330d60f46d68/power-query-regular-expression-capability?forum=sqlkjpowerpivotforexcel 3) http://www.mrexcel.com/forum/power-bi/871103-email-validation-part-sql-query.html (Strange that this post doesn't show up when entering "regular expression" as the keyword in the main search. You have to search in search box on the right navi area. Could this be adjusted?)
- jade_wilderthemNew MemberYes, this would be extremely helpful.
- ravravNew MemberPlease include ASAP regular expression functionality in Power BI. It extremely short development time with DWH and NoSQL etc It will be greatest feature to fliter, clear and stlit data in ETL process. Extremely helpful to validate alse. Thanks.
- steve34New MemberRegEx would be a deal maker! I'd also add a whole bunch of functions, eg, Soundex, Levenshtein etc. I'm still new to Power Query and wonder if i can add functions using "M". If so, then it would be neat if somebody could start are library of these. Similarly, i already use a VBA library of such functions inc RegEx in MS Access. Makes sense to have something similar in Power BI.
- bertrand_d-arb1New MemberExcel users do not have access to R scripting in Power Query. This feature would be even more useful to them.
- g5gwies4_daxNew MemberThis is completely necessary !!! I need to replace a column that "contains" certain data (not the complete occurrence) this is so basic!! please implement it ASAP!! this has been here for so long !! 3 years and you can't put it ?!!
- fbcideas_migusrNew MemberStatus added:New
- miguel
Community Admin
Status changed:NewtoAbandonedDeclining as the idea doesn't have enough information on what's the concrete request or where it should be supported.
Please do feel free to create a new feature with more information about the scenario.
Recent ideas
Blocker: Purview must scan Fabric Warehouse tables/columns or we will deprecate Purview
Purview + Fabric Warehouse ≠enterprise‑ready governance. In our environment, the Fabric Warehouse is the system of record, but Purview can only catalog the warehouse container—not the tables or co...Joshua_Hernande6 hours agoNew MemberNew180Views1like1CommentPower Query Parameter create/use when connecting to a dataflow
In power query when you connect to a table in a dataflow there are no options to create or use a parameter for that dataflow. When connecting to SQL there is an option when setting up the connection ...ben_holmes15 hours agoNew MemberNeed Clarification198Views3likes1CommentParameterize Dataflow Gen2 data source connection
Allow the Dataflow Gen2 data source connection GUID to be parameterized and stored in a Variable Library. This would allow the same Dataflow to use different connections depending on the workspace/e...frithjof_v15 hours agoCommunity ChampionNeeds Votes37Views2likes1CommentExpose Power Query as a Standalone Runtime and Command-Line Interface (CLI)
Summary Power Query has evolved into one of Microsoft's most powerful data transformation technologies and is now used across Excel, Power BI, Fabric, Dataflows, Power Platform, and other products. ...juansgr_15 hours agoNew MemberAbandoned27Views0likes2CommentsExpose User Prompt and Agent Response Logs for Fabric Data Agents
Idea: As an engineer responsible for managing and improving Microsoft Fabric Data Agents, I currently have no way to view how users are interacting with the agents I’ve built. While it’s likely that...JoshuaPitzer17 hours agoAdvocate INew1.2KViews26likes2Comments