transfer data and hyperlink from web to power quary

%3CLINGO-SUB%20id%3D%22lingo-sub-1861369%22%20slang%3D%22en-US%22%3Etransfer%20data%20and%20hyperlink%20from%20web%20to%20power%20quary%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1861369%22%20slang%3D%22en-US%22%3E%3CP%3Ehello%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20in%20Power%20Query%20to%20transfer%20data%20from%20the%20web%2C%20the%20hyperlinked%20text%20is%20transferred%20to%20Power%20Query%20in%20the%20same%20conditions%20and%20works%3F%3C%2FP%3E%3CP%3Eand%20for%20that%20how%20can%20i%20extract%20URL%20code%20from%20web%20for%20many%20items%3F%3C%2FP%3E%3CP%3Ethanks%20for%20your%20attention%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1861369%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1861745%22%20slang%3D%22de-DE%22%3ESubject%3A%20transfer%20data%20and%20hyperlink%20from%20web%20to%20power%20quary%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1861745%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F428949%22%20target%3D%22_blank%22%3E%40SHAYAN1350%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20is%20helpful%20to%20all%20of%20us%20to%20know%20your%20operating%20system%20and%20Excel%20version%2C%20as%20different%20approaches%20may%20be%20required%20depending%20on%20the%20version%20and%20OS.%20Example%3A%20office%20version%20e.g.%202016%20or%202019%20or%20365%20web%20or%20365%20pro%2C%20etc%20and%20your%20operating%20system%20e.g.%20Win10%20(2004)%2C%20Win%2010%20(1903%2C%20Mac%2C%20etc.%3C%2FP%3E%3CP%3EThis%20would%20also%20be%20a%20blessing%20for%20all%20of%20us%2C%20as%20we%20can%20understand%20the%20problem%20much%20better%2C%20a%20win-win%20situation%20for%20everyone.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1862811%22%20slang%3D%22en-US%22%3ERe%3A%20transfer%20data%20and%20hyperlink%20from%20web%20to%20power%20quary%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1862811%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F428949%22%20target%3D%22_blank%22%3E%40SHAYAN1350%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20mean%20to%20extract%20all%20hyperlinks%20from%20webpage%2C%20sample%20could%20be%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fblog.crossjoin.co.uk%2F2018%2F08%2F30%2Fpower-bi-extract-urls-web-page%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EUsing%20Html.Table()%20To%20Extract%20URLs%20From%20A%20Web%20Page%20In%20Power%20BI%2FPower%20Query%20M%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdatachant.com%2F2017%2F05%2F08%2Fweb-scraping-power-bi-part-2%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EWeb%20Scraping%20In%20Power%20BI%20And%20Excel%20Power%20Query%20%E2%80%93%20Part%202%20%E2%80%93%20Extracting%20Links%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20believe%20you%20could%20find%20more.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1864083%22%20slang%3D%22en-US%22%3EBetreff%3A%20transfer%20data%20and%20hyperlink%20from%20web%20to%20power%20quary%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1864083%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3Bthanks%20for%20your%20attention%3C%2FP%3E%3CP%3Emy%20office%20is%202019%20and%20win%2010%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1864153%22%20slang%3D%22de-DE%22%3ESubject%3A%20transfer%20data%20and%20hyperlink%20from%20web%20to%20power%20quary%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1864153%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F428949%22%20target%3D%22_blank%22%3E%40SHAYAN1350%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EWith%20the%20permission%20of%20all%20those%20involved%2C%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20would%20like%20to%20provide%20you%20with%20this%20information%20in%20addition%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3Eto%20the%20very%20good%20and%20very%20interesting%20solution%20proposed%20by%20Mr.%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3ESergei%20Baklan%20%3C%2FA%3E%20%3CSPAN%3E.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3EImport%20data%20from%20external%20data%20sources%20(Power%20Query)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fimport-data-from-external-data-sources-power-query-be4330b3-5356-486c-a168-b68e9e616f5a%3Fui%3Den-us%26amp%3Brs%3Den-%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fimport-data-from-external-data-sources-power-query-be4330b3-5356-486c-a168-b68e9e616f5a%3Fui%3Den-us%26amp%3Brs%3Den%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3Eus%20%26amp%3B%20ad%20%3D%20us%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20patience%20and%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

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 web for many items?

thanks for your attention

10 Replies
Highlighted

@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)

Highlighted
Highlighted

@Nikolino thanks for your attention

my office is 2019 and win 10

Highlighted

@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-be4330...

us & ad = us

 

Thank you for your patience and time.

 

Nikolino

I know I don't know anything (Socrates)

Highlighted

@Sergei Baklan 

Thank You Baklan

 i can't do it in excel but i try to check it in Power BI

Highlighted

@SHAYAN1350 

Yes, sorry, Html.Table() is not available so far in Excel. Parsing of page as text which Gil suggested could work, but you shall to know which kind of links you'd like to extract and how to clean them.

Highlighted

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

Highlighted
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
Highlighted

@Nikolino 

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

Highlighted

@Sergei Baklan 

Thanks Baklan
I was looking for a way to create an Excel file that extract all category of formula in excel from below link by power query, that I can update the ability to access all information and examples of formulas. if it possible help me to do it please.
https://support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26...