Forum Discussion
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 web for many items?
thanks for your attention
10 Replies
If you mean to extract all hyperlinks from webpage, sample could be
Using Html.Table() To Extract URLs From A Web Page In Power BI/Power Query M
Web Scraping In Power BI And Excel Power Query – Part 2 – Extracting Links
I believe you could find more.
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.
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)
NikolinoDE thanks for your attention
my office is 2019 and win 10
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)
us & ad = us
Thank you for your patience and time.
Nikolino
I know I don't know anything (Socrates)
