Using refresh token for an API in power bi desktop

Question

Hello&nbsp;I am trying to call data from an API. My access token is only available for an hour and my current call limits are restricting me to a certain amount of call per second. I am running a Function to call data and the amount of data takes more than an hour to pull. How can I set up the refresh token within power bi desktop? I can get the data ok, but I don't want to be adding new access token when it expires.&nbsp;&nbsp;When requesting a token from the API{&nbsp;&nbsp;&nbsp;&nbsp;"access_token":&nbsp;"my-token",&nbsp;&nbsp;&nbsp;&nbsp;"token_type":&nbsp;"bearer",&nbsp;&nbsp;&nbsp;&nbsp;"expires_in":&nbsp;3600,&nbsp;&nbsp;&nbsp;&nbsp;"refresh_token":&nbsp;"my_refresh_token",&nbsp;&nbsp;&nbsp;&nbsp;"scope":&nbsp;"my_scope"}ThanksJoe

v-jingzhang · Answer

Hi&nbsp;Anonymous&nbsp;
&nbsp;
A common practice is creating a query to get access token from an API and converting it into a custom function. Then in other queries, invoke this custom function to get the token instead of entering a fixed access token.&nbsp;
&nbsp;
Here is an old similar thread for your reference. You would need to modify the code according to your API.&nbsp;
https://community.powerbi.com/t5/Power-Query/Channel-Advisor-API-Connection-with-auth-key-creation/td-p/2208091&nbsp;
&nbsp;
Best Regards, Community Support Team _ JingIf this post helps, please Accept it as Solution to help other members find it.

Forum Discussion

Using refresh token for an API in power bi desktop

1 Reply

Related content

Refresh Power BI Dataset using Power Automate

Refresh issue in desktop

PBI Desktop and SharePoint List Refresh Error

Licence for commercial use - Desktop Version

Desktop Incremental Refresh