Power Query -Data from Multiple pages

[NSCJPN]

Hi
Excel 2016 -Power Query
Need to understand and know

1. How to extract multiple pages data using Power Query. Listing below two websites which has multiple pages of data
   1. https://www.nseindia.com/live_market/dynaContent/live_watch/equities_stock_watch.htm
   2. https://www.bseindia.com/markets/equity/EQReports/MarketWatch.aspx?expandable=2
2. How to access data from website having user id and password?

Chari

 

[RudiS]

For question number 2:

Choose to import from web.
In the dialog, type or paste the link and choose OK
In the next dialog, choose Windows or Basic from the left hand buttons and supply the credentials.

 

[NSCJPN]

Thanks.Had tried, but getting Invalid Credentials error

 

[RudiS]

It may seem to still be a work in progress.

For a workaround, try the advice from Jeff Reed (see the last post in this thread) where you use the Legacy method to connect to the source.

You can also add your vote to excel.uservoice.com surrounding this issue.

Let's hope it is seen to in due time.

 

[NSCJPN]

Legacy option is available only in Office 365.Mine is Excel 2026( Office Prif Plys 2016).
Thanks

 

[sandy666]

with PQ I got tables from both adressess without pass/id and no troubles with credentials https://1drv.ms/x/s!AopTvf3RGAN5j2-G3t7x5U3_yxAr

 

[NSCJPN]

with PQ I got tables from both adressess without pass/id and no troubles with credentials https://1drv.ms/x/s!AopTvf3RGAN5j2-G3t7x5U3_yxAr

Q1 does not require any credentials.it is about extraction of data from multiple tables using power query.

 

[sandy666]

Hm, sorry but I don't see there any more tables than one for each url. so I don't know where is the problem

 

[sandy666]

Maybe use daily report. easier to define parameter(s) for PQ
or
analyse source of this site (each js to find where are the symbols - in js and where is the source of data of this table)