Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
PemaChoki
Regular Visitor

Connect to Indian stock market from https://www.nseindia.com/

I am trying to connect to Indian stock market https://www.nseindia.com/ and pick a historical data for particular stock HCLTECH.

PemaChoki_0-1619413605482.png

While connecting to the web source, all data from the table should be picked and when auto refresh is enable in power Bi, the data picked from web source should be refreshed.

 

Same had been done in yahoo finance and we were successful.

Web source for yahoo finance for stock ARKW picking data for 2 years and interval 1 day

https://query1.finance.yahoo.com/v8/finance/chart/ARKW?range=2y&interval=1d

 

2 REPLIES 2
amitchandak
Super User
Super User

Thank you for the recommendation and prompt response.

 

Actually I am trying to connect to stock historical data through the web source with power BI. 

 

The solution sir have mentioned is at the view level in website.To extra data for particular stock we have have to apply filter at the view level in website.Hope this will not have impact on the auto-schedule that is set on power BI gateway.

PemaChoki_4-1619419500297.png

 

Actually i want is to be able to connect to india stock website, for particular stock pick the stock data daily direcly in power Bi.We have add range in yahoo finance to reduce the data load time.

 

We have set auto schedule for all the stock connected to the yahoo finance.The link enable as to pick the latest stock data updated in the website.If we refresh the data today, today's data in daily for the range two year is picked in power BI.

 

PemaChoki_5-1619420105966.png

https://query1.finance.yahoo.com/v8/finance/chart/FB?range=2y&interval=1d

 


PemaChoki_6-1619420122020.png

 

We have tried the same method with india stock website but it is not working.We are not able to connect to the webiste only.

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors