Forum Discussion

Copper Contributor

Nov 06, 2020

transfer data and hyperlink from web to power quary

hello Is there a way in Power Query to transfer data from the web, the hyperlinked text is transferred to Power Query in the same conditions and works? and for that how can i extract URL code from ...

excel

NikolinoDE

Platinum Contributor

Nov 06, 2020

SHAYAN1350

It is helpful to all of us to know your operating system and Excel version, as different approaches may be required depending on the version and OS. Example: office version e.g. 2016 or 2019 or 365 web or 365 pro, etc and your operating system e.g. Win10 (2004), Win 10 (1903, Mac, etc.

This would also be a blessing for all of us, as we can understand the problem much better, a win-win situation for everyone.

Thank you for your understanding and patience

Nikolino

I know I don't know anything (Socrates)

SHAYAN1350
Copper Contributor
Nov 07, 2020
NikolinoDE thanks for your attention
my office is 2019 and win 10
- NikolinoDE
  Platinum Contributor
  Nov 07, 2020
  SHAYAN1350
  With the permission of all those involved,
  I would like to provide you with this information in addition
  to the very good and very interesting solution proposed by Mr.Sergei Baklan .
  Import data from external data sources (Power Query)
  https://support.microsoft.com/en-us/office/import-data-from-external-data-sources-power-query-be4330b3-5356-486c-a168-b68e9e616f5a?ui=en-us&rs=en-
  us & ad = us
  
  Thank you for your patience and time.
  
  Nikolino
  I know I don't know anything (Socrates)
  - SergeiBaklan
    Diamond Contributor
    Nov 07, 2020
    NikolinoDE , afraid just list of connectors won't help in this case.