I want to use "xpath" to extract data from xml. or to define element I want in web query.
5 Comments
- alan_thomasNew MemberDoes anyone else need to get data from XML files in a more organized/flexible way? I have a set of XML files that I'd like to use, but the hierarchy is a bit too complex to deal with easily. It would be awesome if there were an xPath function! Something like ListOfNodes = XML.xPath(
, ), where each node would be a record from the XML.Document table, but with [Parent = ] metadata. Could work with web-sourced xml too. I almost tried implementing a basic interpreter myself in M, but it's hard without Regular Expression (another feature we badly need) functions to parse anything more complex than "/bookstore/book". Anyone else need this, or manage to build themselves a workaround? - kpjoubertNew MemberHear hear, navigating the trees can be very difficult; an option to use the xpath would be very helpful.
- dhananjay1405New MemberWeb.Content fails in some cases where many nested tables are found containing ultimate information to extract. XPath will be handy to query the exact path of Table
- pdsoutherland2New MemberWould be very useful for accessing data in tables on web sites.
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Power BI UX Suggestion: Preserve Selection When Switching Between Report and Model Views
When developing a Power BI report, if I select a visual in Report View and then switch to Model View, the selected table/column context is lost and everything becomes unselected. This can be inconv...Murtaza_Ghafoor12 hours agoSuper UserNew13Views0likes0CommentsPower BI UX Suggestion: Preserve Selection When Switching Between Report and Model Views
When developing a Power BI report, if I select a visual in Report View and then switch to Model View, the selected table/column context is lost and everything becomes unselected. This can be inconv...Murtaza_Ghafoor12 hours agoSuper UserNew13Views0likes0CommentsDefault Scrollable Time-Series Charts to Most Recent Data
Currently, Power BI time-series charts always open scrolled to the earliest (leftmost) date by default, which is inconvenient for reports where users are interested in the most recent (rightmost) dat...CStillwell14 hours agoNew MemberNew9Views0likes0CommentsPower BI Desktop Data Load: Can We Get Better Progress Visibility?
One UX improvement I’d really like to see in Power BI Desktop is better visibility when loading large datasets from Power Query. Currently, when Power Query finishes processing and the data starts l...salmansaifee7715 hours agoRegular VisitorNew22Views1like0Comments