Home

Missing "Advanced" options from From Web under Power Query in Excel 2013

%3CLINGO-SUB%20id%3D%22lingo-sub-661479%22%20slang%3D%22en-US%22%3EMissing%20%22Advanced%22%20options%20from%20From%20Web%20under%20Power%20Query%20in%20Excel%202013%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-661479%22%20slang%3D%22en-US%22%3E%3CP%3EA%20client%20is%20attempting%20to%20grab%20data%20from%20our%20API%20using%20%22From%20Web%22%20under%20the%20Power%20Query%20tab.%20When%20he%20clicks%20%22From%20Web%22%20and%20then%20%22Advanced%22%2C%20he%20is%20not%20given%20the%20%22Command%20timeout%20in%20minutes%22%20or%20%22HTTP%20request%20header%20parameters%22%20options.%20A%20header%20is%20needed%20to%20pass%20his%20API%20Key%20to%20grab%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20version%20of%20Excel%202013%20does%20have%20these%20options%20so%20I'm%20at%20a%20loss%20as%20to%20why%20they%20are%20missing%20for%20him.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-661479%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
timmdecker
Occasional Visitor

A client is attempting to grab data from our API using "From Web" under the Power Query tab. When he clicks "From Web" and then "Advanced", he is not given the "Command timeout in minutes" or "HTTP request header parameters" options. A header is needed to pass his API Key to grab data.

 

My version of Excel 2013 does have these options so I'm at a loss as to why they are missing for him.

 

 

 

Related Conversations
Power Query/Pivot - Hours not in chronological order
Shahria3 in Excel on
0 Replies
How to add scale breaks in an Excel graph?
Ruben805 in Excel on
1 Replies
Tabellenbereich dynamisch erweitern oder reduzieren?
TheSoulrester in Excel on
0 Replies
Help with data valiation (indirect function)
novakdz in Excel on
0 Replies
Sous totaux excel
Artus _Ophlie in Excel on
0 Replies
How do I lock a excel file that is password protected
dogacakdag in Excel on
3 Replies