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.