Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
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
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.