Skip to main content

Power BI

New

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

b0bb1b2a 76f0-4c00-8264-3ddab3e1d0ac 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

f1a4ed29 cff2-4dec-bf2e-e64f54696ec6 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

6fff3268 a099-41af-941b-e79e1bbd7987 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

37aac34d 30c1-464b-a997-a762b115a284 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?