Forum

Reproducing investo...
 
Notifications
Clear all

Reproducing investopedia terms with power query

11 Posts
3 Users
0 Reactions
225 Views
(@julian)
Posts: 82
Estimable Member
Topic starter
 

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.

 
Posted : 10/08/2018 7:58 pm
(@catalinb)
Posts: 1937
Member Admin
 

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.

 
Posted : 10/08/2018 11:42 pm
(@julian)
Posts: 82
Estimable Member
Topic starter
 

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

 
Posted : 12/08/2018 8:25 pm
(@catalinb)
Posts: 1937
Member Admin
 

Hi Julian,

The file is no longer available, can you please resend a link?

 
Posted : 28/08/2018 2:26 am
(@julian)
Posts: 82
Estimable Member
(@catalinb)
Posts: 1937
Member Admin
 

What should I do with the link you provided? It does not provide access to links or queries.

 
Posted : 28/08/2018 9:45 am
(@julian)
Posts: 82
Estimable Member
Topic starter
 

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.

 
Posted : 28/08/2018 10:25 am
(@catalinb)
Posts: 1937
Member Admin
 

Ok, this means you managed to solve the problem, sounds great.

 
Posted : 28/08/2018 11:02 am
(@julian)
Posts: 82
Estimable Member
Topic starter
 

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

 
Posted : 28/08/2018 5:00 pm
(@mynda)
Posts: 4762
Member Admin
 

Thanks, Julian. That's very kind of you. We sincerely appreciate it.

Mynda

 
Posted : 28/08/2018 9:31 pm
(@julian)
Posts: 82
Estimable Member
Topic starter
 

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 

 
Posted : 25/10/2018 11:38 pm
Share: