none
External table not recognized by Power Query RRS feed

  • Question

  • Hello,

    I'd need to import this table from a web page but Power Query doesn't recognize it. I'd need to extract hyperlinks from it, too. I also tried with Table.FromColumns({Lines.FromBinary(Web.Contents but it didn't work.

    https://www.justetf.com/it/find-etf.html?groupField=none&sortField=yearReturnEUR&sortOrder=desc&tab=rollreturn

    Can someone help me, please?

    Franco

    Thursday, October 17, 2019 12:10 PM

Answers

  • Interesting why my answer was not marked as answer.. but this last one... :)

    Not quite fair


    Query it


    • Edited by jimmy80211 Sunday, November 3, 2019 7:56 AM
    • Marked as answer by Franco Fornari Sunday, November 3, 2019 6:20 PM
    Sunday, November 3, 2019 7:55 AM

All replies

  • Hello

    you could try something like this

    let
        Quelle = Web.Page( Web.BrowserContents("https://www.justetf.com/it/find-etf.html?groupField=none&sortField=yearReturnEUR&sortOrder=desc&tab=rollreturn")),
        Data = Quelle{1}[Data],
        #"Geänderter Typ" = Table.TransformColumnTypes(Data,{{"", type text}, {"Nome del Fondo", type text}, {"Min/max a 52 sett.", type text}, {"1S in %", Percentage.Type}, {"1M in %", Percentage.Type}, {"3M in %", Percentage.Type}, {"6M in %", Percentage.Type}, {"1A in %", Percentage.Type}, {"3A in %", Percentage.Type}, {"5A in %", type text}, {"2", type text}})
    in
        #"Geänderter Typ"

    However no idea how to get all pages

    BR

    • Proposed as answer by Miguel Escobar Sunday, November 3, 2019 6:03 PM
    Saturday, October 19, 2019 2:19 PM
  • Hello,

    unfortunately Web.BrowserContents works in Power BI only and not in Excel Power Query, yet.

    Thanks anyway,

    Franco

    Sunday, October 20, 2019 7:29 AM
  • Hi Franco. Based on the solution Jimmy shared above, my guess is that the table you're interested in is loaded dynamically by javascript, and happens to be loaded after Web.Page takes a snapshot of the HTML. If this is indeed the case, I'm not sure you can extract it without using Web.BrowserContents (which has the ability to wait for a certain amount of time, or for a specific element to appear, before taking its snapshot of the HTML).

    Ehren

    Thursday, October 31, 2019 7:17 PM
    Owner
  • Hi Ehren,

    thanks for your confirmation, it means that I will have to wait for Web.BrowserContent to be added also in Power Query, but I have little confidence for this, because this function has been added in Power BI since more than one year, maybe two.
    Franco
    Friday, November 1, 2019 6:32 AM
  • Interesting why my answer was not marked as answer.. but this last one... :)

    Not quite fair


    Query it


    • Edited by jimmy80211 Sunday, November 3, 2019 7:56 AM
    • Marked as answer by Franco Fornari Sunday, November 3, 2019 6:20 PM
    Sunday, November 3, 2019 7:55 AM
  • Interesting why my answer was not marked as answer.. but this last one... :)

    Not quite fair


    I'm sorry, I didn't want to offend anyone, but in fact no answer resolves my problem until the Web.BrowserContents function is available in Power Query. This is why I closed the discussion at the last answer.

    Sunday, November 3, 2019 6:21 PM