Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am trying to connect to Indian stock market https://www.nseindia.com/ and pick a historical data for particular stock HCLTECH.
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
@PemaChoki , check, you should able to get on this page
https://www1.nseindia.com/products/dynaContent/equities/equities/histHighLowSearch.htm
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.
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.
https://query1.finance.yahoo.com/v8/finance/chart/FB?range=2y&interval=1d
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.
User | Count |
---|---|
40 | |
26 | |
22 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |