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...
Need Help
  • OwenAuger's avatar
    OwenAuger
    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?

OwenAuger's avatar
OwenAuger
Super User
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?