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.
I am trying to configure my query to pull data from an API. I have the API address, secret and key. When I send the secret and key, my answer back is a token (amongst other pieces of information). I then have to take the token from the first call and authenticate again with a user name and password to obtain the actual data I need for the dashboard report. Any suggestions on how to code this so it is automatic?
@vwiles84 , Not very clear, check if you are looking for
https://docs.microsoft.com/en-us/power-bi/developer/automation/walkthrough-push-data-get-token
Not really,
Basically my API requires me to send a security call with the API Secret and Key. In the response from that call, i get a login TOKEN. I then have to make another call with that token and pass it with my website username and password using the API call of the full sales data.
So the first call output looks like this:
Hi @vwiles84 ,
See if this helps
https://community.powerbi.com/t5/Desktop/Fetching-data-using-api-with-key-and-api-secret/m-p/702030
https://community.powerbi.com/t5/Power-Query/Refresh-token-api-call/m-p/937553
Regards,
Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
Sorry, but these links did not help. 😕 I've switched to another dashboard creation so I will come back to this when i am able to try again. thanks for your help.
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.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |