Forum Discussion

SHAYAN1350's avatar
SHAYAN1350
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's avatar
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's avatar
SergeiBaklan
Diamond Contributor
Nov 07, 2020

NikolinoDE , afraid just list of connectors won't help in this case.

  • NikolinoDE's avatar
    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's avatar
      SergeiBaklan
      Diamond Contributor
      Nov 08, 2020

      NikolinoDE 

      Sorry, to try what? I really didn't catch.