# 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%2F20261015%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20261015T203000Z&X-Amz-Expires=86400&X-Amz-Signature=6864cb00f375e07df14e360cac5ab363578c87f8dfdaae360668f87320c47291&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%2F20261015%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20261015T203000Z&X-Amz-Expires=86400&X-Amz-Signature=b4527fd8c8558058ffbb1bb76db84e1354f8a9cba04aa1089bd94fa797ecac1e&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%2F20261015%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20261015T203000Z&X-Amz-Expires=86400&X-Amz-Signature=fc60dd9d54429830e49b4daf299322fa9465e75cc4e22c284979bd65d57a841c&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%2F20261015%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20261015T203000Z&X-Amz-Expires=86400&X-Amz-Signature=9a1016391a8d475613933c68acbc8ce618c9b923c0f465741fd77d57bcb026bd&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%2F20261015%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20261015T203000Z&X-Amz-Expires=86400&X-Amz-Signature=340218cf99e2fab800e736dfe2ee773c1130bf4128437502fac35cde7800f2aa&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%2F20261015%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20261015T203000Z&X-Amz-Expires=86400&X-Amz-Signature=2b0eb29ed2c195b839422f8ca142c8154dddb7b724d76a758670bf62e1b813a0&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%2F20261015%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20261015T203000Z&X-Amz-Expires=86400&X-Amz-Signature=ee5c60ac6005e04ad48b3feeee4d057d6323aeb4180c169e82cfdd9e856d5066&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%2F20261015%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20261015T203000Z&X-Amz-Expires=86400&X-Amz-Signature=a06a393860c29ba9cde3fefea6c477d082325cf5fe74a481324c98e4f805b896&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%2F20261015%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20261015T203000Z&X-Amz-Expires=86400&X-Amz-Signature=3c549f302c98876c9de6515b9a38ba56328f6f5ab993bac6327ce066e1ef3902&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%2F20261015%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20261015T203000Z&X-Amz-Expires=86400&X-Amz-Signature=91ae9bf48d784103088ec8fff609400c2c91fcf70ff814a354c396df90d86d73&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%2F20261015%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20261015T203000Z&X-Amz-Expires=86400&X-Amz-Signature=7d45b22e16f513eed2e559465d22352c3376b3e71b812a09cd7067297f04e054&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%2F20261015%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20261015T203000Z&X-Amz-Expires=86400&X-Amz-Signature=87123c6f6c9768856167bb3c22be98506827375ecdbcbc3d77f8d1189c412420&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%2F20261015%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20261015T203000Z&X-Amz-Expires=86400&X-Amz-Signature=7caae719dafa902ce3f8bef245096cd96b86ee4d852fe0f5e312e4ced50dd587&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%2F20261015%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20261015T203000Z&X-Amz-Expires=86400&X-Amz-Signature=8fdfaf943390b87d32a0ea5cb24a9e3ddd4fd9c46e09a9e9837cd09539b91165&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%2F20261015%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20261015T203000Z&X-Amz-Expires=86400&X-Amz-Signature=b3a3365387555326d86cd8893c1d58761e2e069d66e00fd68a367086a28e873c&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%2F20261015%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20261015T203000Z&X-Amz-Expires=86400&X-Amz-Signature=4996fc4b072f10a0c4090a13644fee1ad768ce52d27067d6e1982dd08442657b&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%2F20261015%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20261015T203000Z&X-Amz-Expires=86400&X-Amz-Signature=0b11237e7dc9c5106d73e257c69a05ad5bfa4991ea7f8f5b66375ff117461991&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%2F20261015%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20261015T203000Z&X-Amz-Expires=86400&X-Amz-Signature=faa6755cd94e885e3824acb678e5d15be20d2851224a723fd77f7488550c37ef&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%2F20261015%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20261015T203000Z&X-Amz-Expires=86400&X-Amz-Signature=58e29339d95829adedeab27ce3b4ba7a87301d35aefd05dfb6a594691586b846&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject " =1920x1080") Padrão para definição dos datasets ---