# Conector PowerBI --- # Consumo de dados no Power BI através de um Custom Connector Esse artigo detalhará o processo de utilização de um Custom Connector através do aplicativo Microsoft Power BI Desktop, aonde é possível consumir as APIs do Portal de Detalhamento Geral e Report Fila para montagem de dashboards com os dados do Convert Voice IP. O objetivo é fornecer um guia claro e conciso para qualquer usuário, garantindo que todos possam integrar e utilizar os dados da API em soluções de BI #### Pré-Requisitos: 1. Possuir o aplicativo do Microsoft Desktop BI instalado, podendo ser feito download em: [Power BI em site oficial da Microsoft](https://www.microsoft.com/pt-br/download/details.aspx?id=58494) 2. O arquivo de Template (.pbit) para ser importado no Power BI 3. O arquivo .mez que será utilizado para o consumo das APIs do Portal 4. Ambos arquivos poderão ser baixados aqui: [Template_Convert_Voice_Connector.zip 3194076](https://s3.us-east-2.amazonaws.com/convert-company-outline/uploads/7afba0e4-20f3-42be-87cd-11b427ca64bd/657d267a-1b29-4e48-9573-8fcec4f6453d/Template_Convert_Voice_Connector.zip?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIAWNEQDAE74GWO55AJ%2F20260922%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20260922T151500Z&X-Amz-Expires=86400&X-Amz-Signature=d29093263ed5ca032f050975284667cc5f18931fb4050ba74bb41ec89244aa45&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject) --- # Criando pastas necessárias para utilização do conector No Windows, acesse a pasta *Documentos* ou *Meus Documentos* podendo ser encontrada abrindo o *Meu Computador* ou o *Menu Iniciar*. ![](https://s3.us-east-2.amazonaws.com/convert-company-outline/uploads/2efff032-394a-42c6-b818-f7f06bf0d1f9/43636a75-4ec9-4619-b839-ff03245fb584/Cria%25C3%25A7%25C3%25A3o_das_pastas_para_utiliza%25C3%25A7%25C3%25A3o_do_Conector.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIAWNEQDAE74GWO55AJ%2F20260922%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20260922T151500Z&X-Amz-Expires=86400&X-Amz-Signature=097bae9bf66ad688473b496cc216d7d22ba5870fe3ed287354f9211d12659a64&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject " =1920x1080")Caminhos a serem criados: *Documentos/Microsoft Power BI Desktop/Custom Connectors* ![](https://s3.us-east-2.amazonaws.com/convert-company-outline/uploads/2efff032-394a-42c6-b818-f7f06bf0d1f9/ae73fb60-78d9-4d7e-8082-ae39978d7071/Criar_pasta_Custom_Connectors.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIAWNEQDAE74GWO55AJ%2F20260922%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20260922T151500Z&X-Amz-Expires=86400&X-Amz-Signature=a427feaafe1057365a50dea32126da36ba5a48dc56dea5239096cf7cc0f6ffa0&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject " =1920x1080")Crie a pasta Custom Connectors dentro da pasta Microsoft Power BI Desktop ![](https://s3.us-east-2.amazonaws.com/convert-company-outline/uploads/2efff032-394a-42c6-b818-f7f06bf0d1f9/3a4dc5ab-f7dc-4275-9900-6a89ed46860d/Cole_a_extens%25C3%25A3o_.mez_disponibilizada_no_arquivo_.zip.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIAWNEQDAE74GWO55AJ%2F20260922%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20260922T151500Z&X-Amz-Expires=86400&X-Amz-Signature=ccb87f11363f6a94cb09553fe76edb58d46917f414d8d186aa50521f1933d539&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject " =1920x1080")Cole a extensão .mez disponibilizada no arquivo .zip **Agora você pode abrir o aplicativo do Power BI para continuar o processo.** --- # Configurando permissões no aplicativo do Microsoft Power BI Desktop **Ao abrir o aplicativo, dirija-se a "Página Inicial" e acesse a aba de "Opções e Configurações assim como na imagem abaixo:** ![](https://s3.us-east-2.amazonaws.com/convert-company-outline/uploads/2efff032-394a-42c6-b818-f7f06bf0d1f9/48186b6e-92c8-4744-a296-74645664f234/Acesse_a_aba_de_%2527Op%25C3%25A7%25C3%25B5es_e_Configura%25C3%25A7%25C3%25B5es%2527.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIAWNEQDAE74GWO55AJ%2F20260922%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20260922T151500Z&X-Amz-Expires=86400&X-Amz-Signature=424e73a3dc813d13ee32d5c9b4fe32374a271611f187883efbbb9224c8e60b62&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject " =1920x1080") Acesse a aba de Opções e Configurações ![](https://s3.us-east-2.amazonaws.com/convert-company-outline/uploads/2efff032-394a-42c6-b818-f7f06bf0d1f9/e141e4a3-e1c0-417b-a1d6-64b7720026dd/Clique_no_bot%25C3%25A3o_%25E2%2580%259COK%25E2%2580%259D_para_confirmar_as_mudan%25C3%25A7as_e_Reinicie_o_aplicativo_para_carregar_as_mudan%25C3%25A7as.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIAWNEQDAE74GWO55AJ%2F20260922%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20260922T151500Z&X-Amz-Expires=86400&X-Amz-Signature=b94f5d98864857d45a2b6d76812e67413de5997a651fb6ae7e2ea6ad840ae18a&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject " =1920x1080") Modifique as opções de segurança e confirme. Reinicie o aplicativo para aplicar as mudanças. --- # Importando template no Microsoft Power BI **Nessa etapa, importaremos o arquivo .pbit que possuí um template de dashboards preparado para carregar os dados do Convert.** ![](https://s3.us-east-2.amazonaws.com/convert-company-outline/uploads/2efff032-394a-42c6-b818-f7f06bf0d1f9/7eaf7d82-00a8-4168-887c-54ee58548ce2/Abra_o_aplicativo_do_Power_BI_Selecione_%25E2%2580%259CRelat%25C3%25B3rio_em_Branco%25E2%2580%259D_para_iniciar_a_importa%25C3%25A7%25C3%25A3o_do_template.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIAWNEQDAE74GWO55AJ%2F20260922%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20260922T151500Z&X-Amz-Expires=86400&X-Amz-Signature=dc4213da5a78a541da2b8cf92af5cbdf8f20d630a6769ff6cac9ac7281e1a817&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject " =1920x1080") Abra o aplicativo do Power BI Selecione “Relatório em Branco” para iniciar a importação do template ![](https://s3.us-east-2.amazonaws.com/convert-company-outline/uploads/2efff032-394a-42c6-b818-f7f06bf0d1f9/a563509a-9348-4c76-97b8-337fbb7a90e8/Acesse_o_menu_de_op%25C3%25A7%25C3%25B5es_atrav%25C3%25A9s_da_aba_arquivo.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIAWNEQDAE74GWO55AJ%2F20260922%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20260922T151500Z&X-Amz-Expires=86400&X-Amz-Signature=a4362e5cc25eee1993eb8525ea41693b1843bcb64351f918817165a3d26f3ec1&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject " =1920x1080") Acesse o menu de opções ![](https://s3.us-east-2.amazonaws.com/convert-company-outline/uploads/2efff032-394a-42c6-b818-f7f06bf0d1f9/c8606b35-3fe3-4c4f-92ad-219ba6b3e081/Cole_o_arquivo_de_extens%25C3%25A3o_.mez_disponibilizado_para_realizar_a_conex%25C3%25A3o_no_Microsoft_Power_BI_Desktop%25281%2529.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIAWNEQDAE74GWO55AJ%2F20260922%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20260922T151500Z&X-Amz-Expires=86400&X-Amz-Signature=23b97b6324ecc4338d192023c4a2e315c00fe7aaf41de056f813d076c780a8a1&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject " =1920x1080") Na opção "Importar", selecione a opção "Modelo do Power BI" ![](https://s3.us-east-2.amazonaws.com/convert-company-outline/uploads/2efff032-394a-42c6-b818-f7f06bf0d1f9/6371634b-0778-43d0-95e5-4bd0b6823662/Cole_o_arquivo_de_extens%25C3%25A3o_.mez_disponibilizado_para_realizar_a_conex%25C3%25A3o_no_Microsoft_Power_BI_Desktop.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIAWNEQDAE74GWO55AJ%2F20260922%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20260922T151500Z&X-Amz-Expires=86400&X-Amz-Signature=6d059edc41ad888eb70ba117da1f26ba1f76937e4043e7c875be1ca41d6e6a34&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject " =1920x1080") Dirija-se até a pasta aonde foi salvo o arquivo .pbit, selecione-o e clique em abrir. ![](https://s3.us-east-2.amazonaws.com/convert-company-outline/uploads/2efff032-394a-42c6-b818-f7f06bf0d1f9/55d5a5fb-3be4-4e6a-831e-3f99981e8843/Carregamento_do_template_.pbit.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIAWNEQDAE74GWO55AJ%2F20260922%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20260922T151500Z&X-Amz-Expires=86400&X-Amz-Signature=09337f31133c8b8de9563127cbe3fee8788b5ef9b987bec4f7c0ceab6cafa453&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject " =1920x1080") Imagem template carregado --- # Carregando os dados para o template **Com o template já carregado, siga os passos abaixo para fazer o consumo das APIs do Portal através do conector.** ![](https://s3.us-east-2.amazonaws.com/convert-company-outline/uploads/2efff032-394a-42c6-b818-f7f06bf0d1f9/3225e9d7-4ceb-4c53-b263-c8534839d4a5/Selecionando_%2527Obter_Dados%2527.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIAWNEQDAE74GWO55AJ%2F20260922%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20260922T151500Z&X-Amz-Expires=86400&X-Amz-Signature=4f38da0d3c669e7bf418caa27ad1695678c28f8937f707387313b24239be7291&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject " =1920x1080") Na aba "Página Inicial" selecione a opção "Obter Dados" ![](https://s3.us-east-2.amazonaws.com/convert-company-outline/uploads/2efff032-394a-42c6-b818-f7f06bf0d1f9/10f136ea-36dd-4a6f-9893-f272be1a865e/Obtendo_dados_pelo_conector.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIAWNEQDAE74GWO55AJ%2F20260922%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20260922T151500Z&X-Amz-Expires=86400&X-Amz-Signature=3ef87b882ba5d962fc25a826be5ed69edddcaf366406816632dd8eb0cfda7f72&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject " =1920x1080") O Menu expandido contém conectores nativos e outras opções customizadas. Procure por "Convert" na caixa de texto para selecionar nosso Conector personalizado. ![](https://s3.us-east-2.amazonaws.com/convert-company-outline/uploads/2efff032-394a-42c6-b818-f7f06bf0d1f9/6614b579-ba68-43a5-a336-ae1db44e670f/Notifica%25C3%25A7%25C3%25A3o_de_conex%25C3%25A3o.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIAWNEQDAE74GWO55AJ%2F20260922%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20260922T151500Z&X-Amz-Expires=86400&X-Amz-Signature=e1ac0c6a4023ec1dee8a5003b471f1baddf385f217430abb05b00c1ed7c5360d&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject " =1920x1080") Uma notificação pode ser exibida antes de utilizar o conector ![](https://s3.us-east-2.amazonaws.com/convert-company-outline/uploads/2efff032-394a-42c6-b818-f7f06bf0d1f9/383b557a-b14f-4f99-89e4-117c54689a3b/Menu_Conector_.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIAWNEQDAE74GWO55AJ%2F20260922%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20260922T151500Z&X-Amz-Expires=86400&X-Amz-Signature=7850064cfd7bca46d9c9d6dbba9db36a1b5f3fd10c2121ebf16aadd76453c2e5&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject " =1920x1080") Ao clicar em continuar, o menu do conector será exibido conforme imagem ![](https://s3.us-east-2.amazonaws.com/convert-company-outline/uploads/2efff032-394a-42c6-b818-f7f06bf0d1f9/e1ec8659-29c7-485b-8b87-b181c9757fe3/Exemplo_de_preenchimento.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIAWNEQDAE74GWO55AJ%2F20260922%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20260922T151500Z&X-Amz-Expires=86400&X-Amz-Signature=4e8a9c4f3ba9b259d5ef9075a55a5759d54b227ff165d50abf717d33514e7853&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject " =1920x1080") Exemplo de preenchimento para executar a consulta: ![](https://s3.us-east-2.amazonaws.com/convert-company-outline/uploads/2efff032-394a-42c6-b818-f7f06bf0d1f9/6c5770fb-84d0-490b-bb32-f158788a2fa5/Dados_carregados.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIAWNEQDAE74GWO55AJ%2F20260922%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20260922T151500Z&X-Amz-Expires=86400&X-Amz-Signature=c67e7c4fc953c6844932df6f24bba70517021387eb8c9b89fed6712718f25cd9&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject " =1920x1080") Dados retornados da API através da consulta no conector ![](https://s3.us-east-2.amazonaws.com/convert-company-outline/uploads/2efff032-394a-42c6-b818-f7f06bf0d1f9/8f53ca3a-c527-4a49-93c4-1c8bbfcab49c/Dashboards.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIAWNEQDAE74GWO55AJ%2F20260922%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20260922T151500Z&X-Amz-Expires=86400&X-Amz-Signature=d47a4703b151c98e9e44594bea543183197d68514069279a69192a494743d43a&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject " =1920x1080") Exemplo de Dashboards preenchidos automaticamente --- # Importante: Observações adicionais ![](https://s3.us-east-2.amazonaws.com/convert-company-outline/uploads/2efff032-394a-42c6-b818-f7f06bf0d1f9/8292b5e4-5f74-45d6-8e59-ba0b0d7294fa/Edi%25C3%25A7%25C3%25B5es_de_consulta.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIAWNEQDAE74GWO55AJ%2F20260922%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20260922T151500Z&X-Amz-Expires=86400&X-Amz-Signature=381ae1f3ee38bb071a918d0ab9f9a5ea039e922d88d4fc0ea9ab6f967971fb74&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject " =1920x1080") Padrão para definição dos datasets --- --- **Documents** - [Manuais de produtos](https://docs.convert.app.br/s/7287dde1-b04f-4cad-9d2b-72f5c721e7d1/doc/manuais-de-produtos-9Zwzl1ufq8) - [Treinamentos em vídeo](https://docs.convert.app.br/s/7287dde1-b04f-4cad-9d2b-72f5c721e7d1/doc/treinamentos-em-video-RtQVBvFmgW) - [Versões de produtos](https://docs.convert.app.br/s/7287dde1-b04f-4cad-9d2b-72f5c721e7d1/doc/versoes-de-produtos-TH4Y8GFXxO)