Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Getting API refresh token for long running query

Hello. I am calling an API to get data into Power BI but am facing an issue that my authorization token expires for the API before the query completes. The JWT Token used for authentication is set to...
Need Help
  • MAwwad's avatar
    MAwwad
    3 years ago

    You could track the start time of the query and then compare it to the current time. If the difference between the start time and current time is greater than 10 minutes, you could make a call to the API URL to extend the session with a new token before continuing with the query.

    Here's some sample code in M language to accomplish this:

    let startTime = DateTime.LocalNow(), result = #"Your data source query", currentTime = DateTime.LocalNow(), timeDiff = currentTime - startTime, renewToken = if timeDiff > #duration(0, 10, 0, 0) then // code to renew token here else null in result

MAwwad's avatar
MAwwad
Icon for Solution Sage rankSolution Sage
3 years ago

You could track the start time of the query and then compare it to the current time. If the difference between the start time and current time is greater than 10 minutes, you could make a call to the API URL to extend the session with a new token before continuing with the query.

Here's some sample code in M language to accomplish this:

let startTime = DateTime.LocalNow(), result = #"Your data source query", currentTime = DateTime.LocalNow(), timeDiff = currentTime - startTime, renewToken = if timeDiff > #duration(0, 10, 0, 0) then // code to renew token here else null in result