Forum Discussion

KUK1390's avatar
KUK1390
Frequent Visitor
3 years ago
Solved

PowerBI - Relative Path

Hi everybody, I wondering if anyone can help me please, I am trying to amend my code to use Relative Path.  I have spent a few weeks setting up this report up but when I went to refresh the sou...
Need Help
  • jbwtp's avatar
    jbwtp
    3 years ago

    I think the code may look like this:

    (page as number) as record =>
    let
        Source = Web.Contents(
                        "https://BP.com/public-api",
                        [
                            RelativePath = "testings/order-service/order/" & Number.ToText(page) & "-" & Number.ToText(page+199),
                            Query = [includeOptional="customFields,nullCustomFields,postalAddresses"], 
                            Headers=[#"bp-app-ref"="kieran", #"bp-account-token"="token"]
                        ]),
        json_doc = Json.Document(Source) 
    in
        json_doc
KUK1390's avatar
KUK1390
Frequent Visitor
3 years ago

Hi jbwtp. 

Many thanks for replying. 

I did have a look at that yesterday but was unsure how to build the query. 

I am going to have another play today and hopefully I will get it working.

The end goal is to have it so my published report can be refreshed.