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

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.
- NikolinoDE
  Platinum Contributor
  Nov 08, 2020
  Was worth a try 🙂
  
  All children are artists. The problem is how to stay an artist when the child grows up.
  (Pablo Picasso)
  
  I know I don't know anything
  Nikolino
  - SergeiBaklan
    Diamond Contributor
    Nov 08, 2020
    NikolinoDE
    
    Sorry, to try what? I really didn't catch.