I'm using Power BI with a REST API as a data source. The API requires authentication via a JWT token. In Power BI Desktop, I created a Power Query function that retrieves a new token using credentials and then applies it to API requests. This works perfectly on my local machine.

However, after publishing to Power BI Service, I can't connect to the API. The dataset shows as offline due to credential issues, and I'm unable to save authentication settings (Anonymous/Organizational). It seems Power BI Service does not execute the function that retrieves the token, causing authentication to fail.

Is there any way to make this work? Does Power BI Service support API authentication with dynamic tokens, or do I need an alternative approach?

I already tried to save the credentials as Anonymous and Organizational, but it didn't save. I also tried to find a way to define a header in Power BI Service with the username and password used in my API to get the JWT token, but I don't think there's a way to do this in app.powerbi.

I expect my report to be able to access my API in the app.powerbi, use the function I created to generate a JWT Token, access the route defined in my query and refresh the table I published

Function to obtain a new JWT Token

let
    GetAuthToken = () as text => 
    let
        authUrl = "https://localhost/api/auth/login",
        authBody = "{""Nome"":""admin"",""senha"":""Teste123""}",
        authHeaders = [
            #"Content-Type" = "application/json",
            #"Accept" = "application/json"
        ],
        authResponse = Json.Document(Web.Contents(authUrl, [
            Headers = authHeaders, 
            Content = Text.ToBinary(authBody), 
            ManualStatusHandling = {400, 401, 403}
        ])),
        token = authResponse[token]  // Ajustado para o nome correto
    in
        token
in
    GetAuthToken

Power Query of a example table

let
    Fonte = Json.Document(Web.Contents("http://localhost/api/operacoes/almoxarifados", [Headers=[Authorization="Bearer " & #"GET Access Token"()]])),
    #"Convertido para Tabela" = Table.FromList(Fonte, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Column1 Expandido" = Table.ExpandRecordColumn(#"Convertido para Tabela", "Column1", {"codigo", "filial", "nome", "ult_Qtd", "ult_Custo", "almoxarifado_de_Venda"}, {"codigo", "filial", "nome", "ult_Qtd", "ult_Custo", "almoxarifado_de_Venda"})
in
    #"Column1 Expandido"