SOLVED

PROBLEM IN MY EXCEL FOR WEB

%3CLINGO-SUB%20id%3D%22lingo-sub-1937444%22%20slang%3D%22en-US%22%3EPROBLEM%20IN%20MY%20EXCEL%20FOR%20WEB%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1937444%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3CPRE%3ENOTIFICATON%20CAME%20WHEN%20I%20REFRESH%20MY%20DETA%20FOR%20AUTOMATIC%20UPDATE%0AAnonymous-%20%3CBR%20%2F%3Euse%20anonymous%20access%20for%20this%20Web%20content%20%3CBR%20%2F%3EWEB%20SITE%20CONTENT%20SHOWN%20HEAR%20HAVE%20ACCESS%20FOR%20EVERY%20PEOPLE%20AND%20MANY%20PEOPLE%20USE%20THE%20SAME%20WAY%20TO%20GET%20DETA%20%0A9%20https%3A%2F%2Fwww.nseindia.com%2Fapi%2Fequity-stocklndices%20%3CBR%20%2F%3EBUT%20ITS%20NOT%20RUNING%20FOR%20ME%20%3CBR%20%2F%3ENOTIFICATION%20SHOWN%20FOR%20ME%20IN%20EXCEL%20(WITHOUT%20USEING%20ANY%20KNID%20OF%20VPN%20)%0A%3CU%3EWe%20couldn't%20authenticate%20with%20the%20credentials%20provided.%20Please%20try%20again.%20%3CBR%20%2F%3E%20SHOWING%20SAME%20RESULTS%20AFTER%20REFRESHING%20OR%20RE%20DONE%20MY%20QUREY%0A%3CBR%20%2F%3E%3C%2FU%3E%3C%2FPRE%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1937444%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1938083%22%20slang%3D%22de-DE%22%3ESubject%3A%20PROBLEM%20IN%20MY%20EXCEL%20FOR%20WEB%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1938083%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F884146%22%20target%3D%22_blank%22%3E%40SUBHASHBHUVAN_19%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3EThat%20could%20have%20something%20to%20do%20with%20the%20Power%20Query%20Web%20connector.%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3EAs%20it%20appears%2C%20they%20are%20using%20a%20VPN%20where%20several%20people%20use%20the%20same%20account%20to%20access%20their%20stock%20market%20data.%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3EDon't%20think%20that%20this%20has%20anything%20to%20do%20with%20Excel.%20But%20who%20on%20I%3F%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3E...%20I%20just%20know%20that%20I%20don't%20know%20anything%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3ETry%20a%20simple%20alternative%20method%20to%20solve%20this%20by%20changing%20%22anonymous%20connection%22%20to%20%22basic%22%20and%20passing%20the%20API%20key%20as%20the%20username%20on%20both%20the%20desktop%20and%20the%20service%3C%2FSPAN%3E.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3ESuggested%20solution%20is%20without%20guarantee%2C%20I%20have%20never%20tried%20it%20that%20way.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3EHere%20is%20some%20additional%20info%3A%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EWeb%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpower-query%2Fconnectors%2Fweb%2Fweb%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpower-query%2Fconnectors%2Fweb%2Fweb%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1938209%22%20slang%3D%22en-US%22%3EBetreff%3A%20PROBLEM%20IN%20MY%20EXCEL%20FOR%20WEB%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1938209%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3B%20%2C%20thank%20you%20for%20reply%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3Bnow%20it%20notifying%20that%26nbsp%3B%3C%2FP%3E%3CP%3E%7Bexpression%20error%20%7Dthe%20user%20agent%20header%20is%20only%20supported%20when%20connecting%20anonymously%2C%20these%20headers%20can%20be%20used%20with%20a%3B%3B%20authentication%20types%3Aaccept%2Caccept%20charset%2Caccept%20encoding%2Caccept%20language%2C%20cachecontrol%2Ccontent%20type%2Cif%20modified%20since%2Cprefer%2Crange%2Creferer%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
 
NOTIFICATON CAME WHEN I REFRESH MY DETA FOR AUTOMATIC UPDATE
Anonymous- 
use anonymous access for this Web content
WEB SITE CONTENT SHOWN HEAR HAVE ACCESS FOR EVERY PEOPLE AND MANY PEOPLE USE THE SAME WAY TO GET DETA 9 https://www.nseindia.com/api/equity-stocklndices
BUT ITS NOT RUNING FOR ME
NOTIFICATION SHOWN FOR ME IN EXCEL (WITHOUT USEING ANY KNID OF VPN ) We couldn't authenticate with the credentials provided. Please try again.
SHOWING SAME RESULTS AFTER REFRESHING OR RE DONE MY QUREY
 

 

 

3 Replies

@SUBHASHBHUVAN_19 

That could have something to do with the Power Query Web connector.

As it appears, they are using a VPN where several people use the same account to access their stock market data.

Don't think that this has anything to do with Excel. But who am I?

... I just know that I don't know anything

 

Try a simple alternative method to solve this by changing "anonymous connection" to "basic" and passing the API key as the username on both the desktop and the service.

Suggested solution is without guarantee, I have never tried it that way.

 

Here is some additional info:

Web

https://docs.microsoft.com/en-us/power-query/connectors/web/web

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

 

best response confirmed by SUBHASHBHUVAN_19 (New Contributor)
Solution

@NikolinoDE  , thank you for reply 

 now it notifying that 

{expression error }the user agent header is only supported when connecting anonymously, these headers can be used with a;; authentication types:accept,accept charset,accept encoding,accept language, cachecontrol,content type,if modified since,prefer,range,referer

You are welcome I am glad that you could find a solution. I wish you continued success with Excel (the coolest invention since chocola... uh ... Microsoft! :-))) And…Please keep asking here - I just taught myself Excel with the help of this forum… nearly :)) Nikolino I know I don't know anything (Socrates)