Log In
Register
Home
December 12, 2016
Offline
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.
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
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.
December 12, 2016
Offline
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
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
Hi Julian,
The file is no longer available, can you please resend a link?
December 12, 2016
Offline
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
What should I do with the link you provided? It does not provide access to links or queries.
December 12, 2016
Offline
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.
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
Ok, this means you managed to solve the problem, sounds great.
December 12, 2016
Offline
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
July 16, 2010
Offline
Thanks, Julian. That's very kind of you. We sincerely appreciate it.
Mynda
December 12, 2016
Offline
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
1 Guest(s)
