Not sure if this is possible but I'm attempting to extract href link in Power query for Excel but have run into an issue that the link text is returned instead of the href. Please see

To this:

As I say im not sure if this is doable but may solve the problem Im having extracting all of the Hrefs.

CodePudding user response：

I've taken a look and I really think this is not possible with PQ. Have you considered scraping the site with something like Power Automate? e.g.