Auto refresh URL with token authentication

[lubosbednar]

I'm having troubles to set up auto refresh when I use http request using url with token authentication. It works in power bi desktop, but I cannot set up auto refresh in power bi service. It doesn't accept Anonymous Authentication method.

Data are extracted as follows:

= Web.Contents("https://app.idoklad.cz/developer/api/IssuedInvoices?PageSize=1000000&Page=1",[Headers=[#"SecureToken...; = "<mytoken>",#"X-App" = "iSmart",#"X-App-Version" = "1.0"]])

Url shows only https://app.idoklad.cz/developer/api/IssuedInvoices?PageSize=1000000&Page=1, without authentication part, so it is obvious that it doesn't accept Anonymous authentication. But how I can provide token using power bi service?

Thanks for help,

Lubos

[v-ljerr-msft · Accepted solution]

@lubosbednar

As mentioned in this similar thread, this is not possible due to constraints with the way Web.Contents stores credentials. And there are also some workaround mentioned in that thread, please go and try to see if the solution works.

Regards

[lubosbednar]

Thanks for your help @v-ljerr-msft. Workaround with RelativePath worked for me. Great!