This article describes how to download not only textual content from a web page, but also “hidden” hyperlinks themselves.

We can use table from this page:

Power Query – how to simply get hyperlinks from webpages

Connect to web and select the table:

Power Query – how to simply get hyperlinks from webpages

and load.

In Power Query new table appears, but without hyperlinks.

Power Query – how to simply get hyperlinks from webpages

Go to the second step of flow, “Extracted Table From HTML”, where the Html.Table function is used.

Add new column, which extract hyperlinks:

  • {“SomeColumn”, “a”, each [Attributes][href]},

So it looks like this:

  • = Html.Table(Source, {{“SomeColumn”, “a”, each [Attributes][href]}, {“Column1”, “TABLE > * > TR > :nth-child(1)”}, {“Column2”, “TABLE > * > TR > :nth-child(2)”}, {“Column3”, “TABLE > * > TR > :nth-child(3)”}}, [RowSelector=”TABLE > * > TR”])

Power Query – how to simply get hyperlinks from webpages

And hyperlinks are here.

If you define their data category:

Power Query – how to simply get hyperlinks from webpages

You can click on them in reports:

Power Query – how to simply get hyperlinks from webpages