Forum Discussion

manuelmesquita's avatar
manuelmesquita
Frequent Visitor
4 years ago
Solved

I need help how to HTML Extrat Multiple links in multiple rows in a Web Page

Hello, I need help how to HTML Extrat Multiple links in multiple rows in a Web Page. My example is: let Source = Web.BrowserContents("https://www.base.gov.pt/Base4/pt/detalhe/?type=contratos&id=8...
  • v-janeyg-msft's avatar
    v-janeyg-msft
    4 years ago

    Hi, manuelmesquita 

     

    I don't know what the rules are in the links because I don't understand the language.

    I searched for some ways, hope it helps:

    Use Power BI Web From Example over multiple URLs 

    Extracting Data from Complex Web Pages with Power BI - Excelerator BI

    use power Query to extract hyperlinks from a web table (microsoft.com)

     

    Best Regards,

    Community Support Team _Janey

    If this post helps, then please consider Accept it as the solution to help the other members find it more.

  • v-janeyg-msft's avatar
    v-janeyg-msft
    4 years ago

    manuelmesquita 

     

    I have sent you the doc for getting the URLs, if you know the rule between the URLs you need.

     

    As for why this method is useless, I don't know if you have tried changing it to http

     

     

    If http is useless, it should be that the url is encrypted, you can see the base4...id or something behind it, I don't know html, I can only see this...binary code? Splitting the url after encryption doesn't seem to work.  So it should be the security of the website, not your code.

     

    Best Regards,

    Community Support Team _Janey

    If this post helps, then please consider Accept it as the solution to help the other members find it more.