This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
Hello,
I need to connect in API with method POST and authorization token, but the response is problem with annonymous authentication.
I tried with M language:
let
content = "{""filtro_body"": {""assunto"": """", ""codigo"": """", ""nome_contato"": """", ""email_conferencia"": """", ""data_criacao"": """", ""data_solucao"": """", ""cliente_token"": """", ""cliente_id"": """", ""status"": """", ""tecnico"": """", ""cliente"": """", ""mesa_trabalho"": """", ""categoria_primaria"": """", ""categoria_secundaria"": """", ""total_avaliacao"": """", ""descricao_avaliacao"": """", ""setor"": """", ""tipo_ticket"": """", ""dispositivo"": """", ""possui_avaliacao"": true, ""prioridade"": 1, ""data_hora_criacao_inicial"": """", ""data_hora_criacao_final"": """" } }",
Source = Json.Document(Web.Contents("https://apiintegracao.milvus.com.br/api/chamado/listagem",
[Headers=[#"Authorization"="token",
#"apikey" = "KEY123",
#"filtro_body" = "{}",
#"ContentType"="application/json"],
ManualStatusHandling = {404, 400},
Content=Text.ToBinary(content)]))
in
Source
And I tried with Web Data Source, and not works:
The API link I'm trying to connect:
https://developers.milvus.com.br/#api-Chamado-listagemChamados
Anyone can help me, please?
Sorry about my English level.
Most likely you need to use "Bearer " & token
As you can probably appreciate it is nearly impossible to help with API queries without access to said API (which you may not be willing to provide for understandable reasons)
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 1 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 9 | |
| 5 | |
| 3 | |
| 3 | |
| 2 |