Can't save dataflow "One or more tables references a dynamic data source

[MithSingh]

Hello Everyone,

I can't be able to save it, I have been trying to resolve it from last almost a month but have had no luck yet.

let

  Source = List.Generate( () =>

        [ URL = "https://LPF.api.goflow.com/v1/orders?filters[date:gte]=2023-05-05T00:00:00Z" , Result = Json.Document(Web.Contents(URL,[Headers=[Authorization="Bearer xxxxxxxxxxxxxxxxx"]])) ],

        each [URL] <> null,

        each [ URL = [Result][next] , Result = Json.Document(Web.Contents([URL],[Headers=[Authorization="Bearer xxxxxxxxxxxxxxxxx"]])) ]

    ),

  #"Convert to table" = Table.FromValue(Source)

in

  #"Convert to table"

[ppm1]

Please see this article about using the RelativePath and Query terms in Web.Contents.

Chris Webb's BI Blog: Using The RelativePath And Query Options With Web.Contents() In Power Query An...

Pat