ModelRefresh_ShortMessage_ProcessingError when I try to refresh API Auth

[CSpina]

Falha na última atualização: Thu Apr 09 2020 14:53:35 GMT-0300 (Horário Padrão de Brasília) Erro durante o processamento de dados no conjunto de dados.Ocultar detalhes Erro de fonte de dados: {"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"Information is needed in order to combine data"}}],"exceptionCulprit":1}}} Table: RequestTarefas. Cluster URI: WABI-BRAZIL-SOUTH-B-PRIMARY-redirect.analysis.windows.net ID da atividade: 7b97bd8a-b0c5-4d88-9018-099ff0df6e0b Solicitar ID: 34e36ef0-42d2-de5c-76ea-7f94e6e117a9 Hora: 2020-04-09 17:53:35Z

let getToken = Json.Document(
        Web.Contents(
            "https://api.none.com.br/v2/login/",
            [
                Headers=[#"Content-Type"="application/json"],
                Query=
                [
                    apiToken = Text.From(apiToken),
                    apiKey= Text.From(apiKey)
                ]

                
            ]
        )
    ),
    result = getToken[result], 
    authToken = "Bearer " & result[accessToken],
    
    paramFilter = "{
            ""startDate"" : ""2020-04-01T00:00:00""
            , ""endDate"": ""2020-04-30T23:59:59""
        }",

        selectFields = "taskID,idUserFrom,idUserTo,customerId, taskType,creationDate,taskDate,latitude,longitude,orientation,finished,report,checkIn,checkInDate,checkOut,checkOutDate,pendency,taskStatus",
        
        Fonte = Json.Document(
            Web.Contents(
                "https://api.none.com.br/v2/tasks/",
                [
                    Headers=[Authorization=authToken,
                    ContentType="application/json"],
                    Query=
                    [
                        page = Text.From("1"),
                        pageSize= "200",
                        paramFilter=Text.From(paramFilter),
                        selectFields=Text.From(selectFields)
                    ]

                    
                ]
            )

        )

 in

  Fonte

[v-xuding-msft]

Hi @CSpina ,

I think you could create a support ticket to get the dedicated support. It is a safe and quick way.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[CSpina]

Thanks for your answer.

I can not open a ticket, I am still evaluating Power BI.

I need to run tjis report in order to buy.

[v-xuding-msft]

Hi @CSpina ,

Sorry I didn't help you. Hope someone can solve it. And if you will resolve it later, please share the solution here.  More people who encounter the same issue will benefit this thread.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.