Forum Discussion

TK12345's avatar
TK12345
Resolver II
3 years ago
Solved

Help with syntax -'One or more table references a dynamic Data Source. Not able to save dataflow'

Hi there,  I have an API that I want to paginate in a Power BI Dataflow. I tried this code in the desktop (dataset) and it refreshes fine. It also shows data in the dataflow but when I close the dat...
Need Help
Show and Tell
Tips and Tricks
  • lbendlin's avatar
    lbendlin
    3 years ago

    Put the query pairs into the Query section, not the Relative path section.

  • TK12345's avatar
    TK12345
    3 years ago

    Thanks, that did the trick.

    Solved it like this:

    (Page as number) as table=>

    let
      Source =
      Json.Document(
        Web.Contents("https://www.cannotshow.nl",
        [RelativePath = "/test.test/rest/all/V1/orders",
        Query = [
          #"searchCriteria[pageSize]" = Text.From(10),
          #"searchCriteria[currentPage]" = Number.ToText(Page)
          ],
          Headers=[
           #"Authorization" = "Bearer abcdefgheijklmnop"
        ]])
lbendlin's avatar
lbendlin
Super User
3 years ago

Put the query pairs into the Query section, not the Relative path section.

TK12345's avatar
TK12345
Resolver II
3 years ago

Thanks, that did the trick.

Solved it like this:

(Page as number) as table=>

let
  Source =
  Json.Document(
    Web.Contents("https://www.cannotshow.nl",
    [RelativePath = "/test.test/rest/all/V1/orders",
    Query = [
      #"searchCriteria[pageSize]" = Text.From(10),
      #"searchCriteria[currentPage]" = Number.ToText(Page)
      ],
      Headers=[
       #"Authorization" = "Bearer abcdefgheijklmnop"
    ]])