I'm trying to link to a dictionary provided by Investopedia.com with a slicer of 26 English letters plus a "#" mark. Under each option there are hundreds of terms available with a hyperlink to blow by blow explanations respectively. I'm not quite familiar with the tactic of iterating over multiple pages of web data using power query. Hopefully someone can help me out. Thanks in advance.
Hi Julian,
First, you have to provide a table with text links, not hyperlinks attached to cells, power query will not read hyperlinks.
However, your links are pointing to .asp pages, you can only get data from html pages.
Hi Catalin,
Please take a look at the attached file and you'll find I've solved part of the issues. The rest portion is to obtain the whole dictionary indices by reiterating the multiple pages over the web data using two parameters for alphabet and page numbers in M language. Would you like to try it out? Thanks.
Julian
Hi Julian,
The file is no longer available, can you please resend a link?
What should I do with the link you provided? It does not provide access to links or queries.
Once click any link icon then I'll go to the target web-page. That's what I expected to do in my Power BI desktop / Excel Power-Query instead of searching the web directly. What I've learned from this exercise is how to iterate over multiple pages of web data using power query. That's it.
Ok, this means you managed to solve the problem, sounds great.
Hi Catalin,
Please tell Mynda I've made a small donation with a "dummy" order #56421 on August 21th to honor my promise given one year ago. Thanks again for all the tutorials I've been learning from My Online Training Hub.
Best regards,
Julian
Thanks, Julian. That's very kind of you. We sincerely appreciate it.
Mynda
Dear Sir or Madam,
Please be informed Philip Treacy has published another approach by using VBA in his blog scraping multiple web pages. I can't wait to recommend it.
Julian