Airtable - Power Bi Service = Dynamic Source Refresh Error

Hi,
I have a M query below which works fine in Power Bi Desktop but fails in Power Bi Service due to Query 1 Dynamic Source Refresh error.

I understand that I need to add amend to add a Relative Path to make this work but after numerous attempts am now stumped.

Any suggestions please?

let
Pagination = List.Skip( List.Generate( () => [Page_Key = “init”, Counter=0], // Start Value
each [Page_Key] <> null, // Condition under which the next execution will happen
each [Page_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(“https://api.airtable.com/xxxxx”, [Headers=[Authorization=“Bearer keyxxxxxxx”]]))
else Json.Document(Web.Contents(“https://api.airtable.com/xxxxx?offset=”&[WebCall][Value][offset] , [Headers=[Authorization=“Bearer keyxxxxxxx”]])),// retrieve results per call
Counter = [Counter]+1// internal counter],
each [WebCall]

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.