Is it possible to parameterise a url such that url title display as href - PQ

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 here for more info.

Struggling to find a solution but as a last-ditch attempt im wondering if its possible to parameterise a URL such that the page displays the URL in full instead of a link i.e when I hover over BP in the images below:

From this:

To this:

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

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. https://www.youtube.com/watch?v=DgBZiBIgh3w

EDIT 1: Try this:

let
    Source = Excel.Workbook(Web.Contents("https://echa.europa.eu/search-for-chemicals?p_p_id=disssimplesearch_WAR_disssearchportlet&p_p_lifecycle=2&p_p_state=normal&p_p_mode=view&p_p_resource_id=exportResults&p_p_cacheability=cacheLevelPage&_disssimplesearch_WAR_disssearchportlet_sessionCriteriaId=dissSimpleSearchSessionParam101401654440118533&_disssimplesearch_WAR_disssearchportlet_formDate=1654440118558&_disssimplesearch_WAR_disssearchportlet_sskeywordKey=Acetone&_disssimplesearch_WAR_disssearchportlet_orderByCol=relevance&_disssimplesearch_WAR_disssearchportlet_orderByType=asc&_disssimplesearch_WAR_disssearchportlet_exportType=xls"))[Data]{0}
    
    
    
in
    Source

EDIT 2:

In FireFox, open developer tools with F12. Go to the Network tab in the dev tools. Click the export button on the web page for CSV or XLS. A new entry will appear in the network tab. Highlight it and then look at the request parameters that were sent.