Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hello 🙂 Can someone help me with this API call?
I need a NEW token for each line. When I refresh the function getToken it's refreshes ok, but when I invoke in the date tables it still the same for all rows.
Function:
() =>
let
bodyToken = "{#(lf) ""Usuario"":""xxxxxx"",#(lf) ""Senha"":""xxxxxx"",#(lf) ""NumeroSerialLoja"":""xxxxxx"",#(lf) ""Chave"":""Serial Number""#(lf) }",
getToken = Json.Document(Web.Contents (
"http://chefweb.chef.totvs.com.br/", [RelativePath="chefwebapi/api/Token/GerarToken",
Headers=[#"Content-Type"="application/json"],
Content=Text.ToBinary(bodyToken)
]
)),
token = getToken[Token]
in
token
Table with dates:
let
days = Duration.Days(endDate - startDate),
listDates = List.Generate(
() => 0,
each _<= days,
each _ +1,
each Date.AddDays(startDate,_)
),
#"Converter em tabela" = Table.FromValue(listDates),
#"Tipo de coluna alterado" = Table.TransformColumnTypes(#"Converter em tabela", {{"Value", type date}}),
#"Função personalizada invocada" = Table.AddColumn(#"Tipo de coluna alterado", "Função personalizada invocada", each getToken())
in
#"Função personalizada invocada"
Description updated. Can someone help me?
Hi @gbernardes ,
Please review the following links, hope they can help you.
I stumbled over a similar problem as you last year. I solved my api connection by buidling a custom data connector.
https://github.com/Microsoft/DataConnectors
With the connector you have a lot of possibilitys for authentication handling:
see: https://docs.microsoft.com/en-us/power-query/handlingauthentication
The custom Connector can be attached to the data gatway from there the api calls are made.
This is not a really easy way for sure but may be a solution.
Power Query Advanced Editor Update Access Token with Refresh Token
It is not a easy task to automatically get refresh token and use the token in Power Query. I would recommend you check Robert's reply in the similar thread below to create functions to implement the process.
https://stackoverflow.com/questions/40753188/google-oauth-refresh-tokens-in-power-query
Best Regards
How are you updating the value in the parameter? Does it refresh/update to show the new token value every time you make a new call?
@dhruvinushah Every time I refresh the table "getDados" the token refreshes. But only 1 time. I need the refresh for every row in the table.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
84 | |
75 | |
68 | |
41 | |
35 |
User | Count |
---|---|
102 | |
56 | |
52 | |
46 | |
40 |