Skip to main content

Power BI

Needs Votes

xpath

Vote (30) Share
's profile image

on 10 Nov 2016 13:19:23

I want to use "xpath" to extract data from xml.
or to define element I want in web query.

Comments (4)
's profile image Profile Picture

Paul Southerland on 10 Jul 2020 17:20:45

RE: xpath

Would be very useful for accessing data in tables on web sites.

's profile image Profile Picture

Dhananjay Gokhale on 06 Jul 2020 00:14:55

RE: xpath

Web.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

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:11:41

RE: xpath

Hear hear, navigating the trees can be very difficult; an option to use the xpath would be very helpful.

's profile image Profile Picture

alazyworkaholic on 05 Jul 2020 22:37:35

RE: xpath

Does 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?