How to connect web URL in Power BI

[Anonymous]

Hi Team,

Issue 1:

Am trying to connect bellow one url's in power bi desktop but it taking huge time and am getting message like waiting for website name. 

URL 1: https://www.nseindia.com/market-data/live-equity-market

Issue 2:

am getting black screen while connecting URL 2

URL 2 : https://www.covid19india.org/

Please help on this how to get this data into Power BI desktop.

Thanks in advance

[mwegener]

Hi @Anonymous ,

the web pages work asynchronously with JavaScript. You should use the web tools of your web browser to identify the query with the data.

The following urls should work.

https://www.nseindia.com/api/equity-stockIndices?csv=true&index=NIFTY%2050

https://api.covid19india.org/v4/min/data.min.json

[Anonymous]

Thanks for quick response.

1st URL not working am getitng Resource not found error

2nd URL taking huge time to load and sometime system getting hang

What are the web tools of web browser to identify the query with the data.

[mwegener]

Hi @Anonymous ,

nowadays almost every browser has these development tools, you can usually access them by pressing [F12]. It may be that the website prevents corresponding query by tools like Power BI.

[Anonymous]

Thanks for response 

both URL's taking huge time to connect 
have set time out to 60 mins but no luck to connect.