Schedule refresh fail - API with token

[Snap]

Hi, 

I have followed some instructions on getting a dynamic token to pull some information from a webiste. The function sends my credentials in order to get a token. This token then gets used for other API request to pull information. It all works well in desktop but as soon as I publish to the service it fails and I can't refresh.

Query to get token:

Query to get information using the token:

Error I get on the service when trying to manaually or schedule a refresh:

Any help will be appreciated

[v-deddai1-msft]

Hi @Snap ,

Please use something like:

Source = Json.Document(Web.Contents("xxxxxxxx", [
  RelativePath="api/accounts",
  Query=[token=#"Get Token"()]
 ]))

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[Snap]

Seems to still give me a smilar error. It refreshes in desktop but as soon as I publish (that works) and try to refresh it gives me the below error. 

[v-deddai1-msft]

Hi @Snap ,

Not very sure about your issue since I can't reproduce it in my environment.  I think may be you have contains password and username in the url directly in your token function. I suggest you refer to  https://chris.koester.io/index.php/2015/07/16/get-data-from-twitter-api-with-power-query/  to modify your code and try again.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[Anonymous]

See PBRS it works with no API limitations - https://go.christiansteven.com/knowledge/pbrs-for-power-bi/using-pbrs/how-do-i-configure-pbrs-api