Forum Discussion
Refreshing Bearing Token
I'm attempting to create a system that will pull data from an API that requires a token. While I was figuring everything else out I was just requestion the authorization in a query and then copy and pasting the response. I will have 15-20 different queries all that will need the token on a daily basis.
Can someone direct me to someplace that would show me how to;
1) Query for the authorization and then just use that query in the other queries
2) A way to refresh the token on a daily basis automatically.
Any help would be appreciated.
Thank You,
3 Replies
1. Handling authentication for Power Query connectors - Power Query | Microsoft Learn
2. What for? Your query can run for a maximum of five hours before it gets cancelled by the Power BI service.
1. I already have the authentication. I did that in a seperate Query because it requires connecting to a different endpoint of the same API then the endpoint I'm pulling the data from. What I'm trying to figure out is how to get that token into the authentication of other queries. Seems like it should be simple because I have the information from the authorization in a table. I *think* I should be able to just say something like "Authorization = Name of the field the token is in"
2. I'm doing this in Excel and will be pulling the data from Excel into another program. It will not be a continuous run but I planned on using the "Refresh Query" property. The token expires every 2-3 days.
Slightly different format
"Authorization= Bearer " & token
