Authorization Header Gone

Hi Anonymous, 

I have reported this issue internally: CRI 183348894. Will update here once I get any information. 

Best Regards,
Qiuyun Yu

Hi Anonymous. In the March release, we restricted the list of headers shown in the UI to those that we support for all auth types. Some folks on the team also feel that showing the Authorization header might encourage people to put credentials into their query, which is unsafe. That said, the dropdown box, in addition to allowing you to select from the list, also allows you to type an arbirary header value. So as a workaround, you can always manually enter "Authorization", even though it no longer shows up in the list.

Thanks Ehren for the response. Since I'm a newb at PowerBi and not a programmer, how do I manually enter Authorization? 

I copied a formula I got from a different post into the Power Query but it doesn't refer to the authorization. It works but didn't know if there is a better way to do it. I also have more than the 100 records allowed so I use the Pagination code. 

let
Pagination = List.Skip(List.Generate( () => [Last_Key = "init", Counter=0], // Start Value
each [Last_Key] <> null, // Condition under which the next execution will happen
each [ Last_Key = try if [Counter]<1 then "" else [WebCall][Value][offset] otherwise null,// determine the LastKey for the next execution
WebCall = try if [Counter]<1 then Json.Document(Web.Contents("airtable address?api_key=key))
else Json.Document(Web.Contents("airtable address?api_key=key"&Last_Key&"")), // retrieve results per call
Counter = [Counter]+1// internal counter
],
each [WebCall]
),1)
in
Pagination

Hi Anonymous. I updated my reply above. You shouldn't need to do any fancy M-wrangling. Simply type the value "Authorization" into the dropdown box.

Ehren

Excellent thank you so much! That pulled in the data I needed and then I can use the pagination code to retrieve all of the rows since PowerBi stops at 100 in Power Query.