Skip to main content

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 cPage_Key] <> null, // Condition under which the next execution will happen

each cPage_Key = try if Counter]<1

then “”

else >WebCall]WValue]]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”, xHeaders=Authorization=“Bearer keyxxxxxxx”]]))

else Json.Document(Web.Contents(“https://api.airtable.com/xxxxx?offset=”&?WebCall]/Value]aoffset] , lHeaders=[Authorization=“Bearer keyxxxxxxx”]])),// retrieve results per call

Counter = aCounter]+1// internal counter],

each oWebCall]

Be the first to reply!

Reply