Authorization Header Gone
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