Forum Discussion

MichaelMM's avatar
MichaelMM
Regular Visitor
1 year ago
Solved

Dynamic Data Source Error / RelativePath / Cursor Pagination / Headers

Hi,    I need help updating my data source in the cloud. The problem is that it is a dynamic data source with headers and Cursor pagination. I have investigated the use of RelativePath but cannot...
  • OwenAuger's avatar
    1 year ago

    Hi MichaelMM 

    I tinkered around a bit and I was able to "Test connection" in the Power BI Service with this version of the query:

    let
      Kilde = List.Numbers(250000, 160, 1000),
      #"Konverteret til tabel" = Table.FromList(Kilde, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
      #"Ændret type" = Table.TransformColumnTypes(#"Konverteret til tabel", {{"Column1", type text}}),
      #"Tilføjet brugerdefineret" = Table.AddColumn(
        #"Ændret type",
        "Brugerdefineret",
        each Json.Document(
          Web.Contents(
            "https://apis.e-conomic.com",
            [
              RelativePath = "bookedEntriesapi/v3.2.0/booked-entries",
              Query        = [cursor = [Column1]],
              Headers      = [#"X-AppSecretToken" = "XXX", #"X-AgreementGrantToken" = "XXX"]
            ]
          )
        )
      ),
    //...

    Does this work for you?