Airtable - Power Bi Service = Dynamic Source Refresh Error

709 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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?

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(“”, [Headers=[Authorization=“Bearer keyxxxxxxx”]]))
else Json.Document(Web.Contents(“”&[WebCall][Value][offset] , [Headers=[Authorization=“Bearer keyxxxxxxx”]])),// retrieve results per call
Counter = [Counter]+1// internal counter],
each [WebCall]

0 Replies 0