cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rahul1 New Member
New Member

How to import tables from web?

Hi,

 

I need to import tables from 110 web links. Is there a way I can write a script to get those tables?

I do not want to fetch tables from one link at a time?

 

Example of the links are as follows:

 

www.test.com/1

www.test.com/2

www.test.com/3

 

So i want to write While Do script and use it to get the data.

 

Regards,

 

Rahul

4 REPLIES 4
Super User
Super User

Re: How to import tables from web?

What I would recommend that you do is create queries for two of the entries and then in one of the queries, merge them together. You can follow the instructions in my article here:

http://social.technet.microsoft.com/wiki/contents/articles/32915.powerbi-merge-query-with-m.aspx

 

Once you have the M code, then write a script to generate the M code for merging all 110 web link sources. Create a blank query and paste in the generated M code.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


vignesgangboard Frequent Visitor
Frequent Visitor

Re: How to import tables from web?

  1. Click the Microsoft Office Button , and then click Open.
  2. In the Look in box, locate Hadoop Training in Chennai the folder where your query file is stored.
  3. Select the Web query that Hadoop Course in Chennai you want to run.
  4. Click Open.
  5. In the Import Data dialog box, do one of the following:
vignesgangboard Frequent Visitor
Frequent Visitor

Re: How to import tables from web?

  1. Click the Microsoft Office Button , and then click Open.
  2. In the Look in box, locate the folder where your query file is stored.
  3. Select the Web query that Hadoop Training in Chennai you want to run.
  4. Click Open.
  5. In the Import Data dialog box, do one of the following:
Anoushka Frequent Visitor
Frequent Visitor

Re: How to import tables from web?

Click the Data tab, then New Query > From Other Sources > From Web.

Regards: Big Data Course in Chennai | Big Data Hadoop Training | Cloud Computing Courses