Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi guys,
I need some help to solve a problem I can't find the solution.
I want to connect PowerQuery to a API that the token change automatically all the time. I tried to make a parameter to capture the token and built the complete URL of the API using that parameter but it doesn't work well. I can connect the API for a couple of minutes but crash later.
Anyone know how to solve it??
The URL to get the token is this one:
The API is this (the value of the token continue after the equal sign, of course):
Thanks a lot !!!
Solved! Go to Solution.
If you create a blank query with Web.Contents (or use the Web connector) and use your Token URL, so you get a token in response? If so, right click on the "cell" containing the token and choose "Drill Down" to get to just the text value. Name that query something relevant and then use that name as part of a concatenated string in your second web call.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Instead of a parameter, you can make a query to retrieve your token and "drill down" so the output is a text value (instead of a table). You can then use the result of that query in your second query.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi Mahoneypat,
Thanks a lot for your answer, I really appreciate it.
I don't know how can I do that 😞
If you create a blank query with Web.Contents (or use the Web connector) and use your Token URL, so you get a token in response? If so, right click on the "cell" containing the token and choose "Drill Down" to get to just the text value. Name that query something relevant and then use that name as part of a concatenated string in your second web call.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.