Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Airtable - Power Bi Service = Dynamic Source Refresh Error

805 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Steve_Simmonds
4 - Data Explorer
4 - Data Explorer

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]

0 Replies 0