Hi all,
I have built a dataflow which retrieves data from the Power BI REST API.
One of its use cases is to get all users who have access to the reports of our organization.
These are the steps that are executed in the flow to achieve it:
- I created a function that returns an access token, which works just fine
- The token is being used to call the /reports endpoint in order to return all report IDs
- I am using the list of IDs to perform a call for every single report ID using a relative path to the /reports/*ID*/users endpoint to get me the users of each report
Everything worked fine until some day - due to more reports and more users - the flow runtime exceeded 1 hour.
After 1 hour the entire flow will fail because the access token I am retrieving through my query function expires.
This made me realize that the logic of the flow I built is not working in the way I thought it was.
I thought - by using a function for retrieving an access token - every single call to an API endpoint will use its own new access token.
This is apparently not the case. The same old token is beeing used for every element in my report ID list.
My question: How can I fix this. Is there a way, to rewrite the function, so that it generates a new key for every request?
The logic of my function currently looks like this:
let
body = [
grant_type = "client_credentials",
resource = "https://analysis.windows.net/powerbi/api",
client_id = "*********************",
client_secret = "***********************************",
scope = "https://analysis.windows.net/powerbi/api/.default"
],
GetJson =
Json.Document(
Web.Contents(
"https://login.microsoftonline.com/***********************/oauth2/token", [
Headers = [#"Content-Type" = "application/x-www-form-urlencoded"],
Content = Text.ToBinary(Uri.BuildQueryString(body))
]
)
),
access_token = GetJson[access_token]
in
access_token
Thanks in advance
Tim
