Forum Discussion
Schedule refresh fail - API with token
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
4 Replies
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
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
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.
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
