Hi, I would love to send data from Pipefy to PowerBi and have interactive dashboards to keep track of my processes SLAs. Does any one here ever done that?
Currently, I am using pwbi using the connector and to automate the sync daily I installed the Gateway. It is working perfectly. The connector has some limits when dealing with huge amount of rows, but most of the case we do not reach it. Additionally, we developed a middleware that uses Pipefy APIs and store data into a MariaDB in our Google Cloud environment hair transplant turkey. We created a VM for it. We also replicated this scenario for a customer which is integrating Pipefy data with other applications and the main database (customers) is located in an proprietary system (no API available).
Yes, it's possible! You can use Pipefy's API to extract data and connect it to Power BI, either directly or through tools like Power Automate, Google Sheets, or a SQL database. This allows you to create interactive dashboards and track your process SLAs effectively. Many users have done it—just takes a bit of setup!
Olá pessoal!
Venho compartilhar a solução que eu encontrei para o mesmo problema citado acima (Missing required parameter: scope.) com o conector. Em meu caso também gerava a mensagem:

Basicamente o conector faz a integração API com o pipefy, e na mensagem está indicando que falta um parâmetro a ser enviado junto aos demais (Como senha, usuário, etc), que é o scope (escopo).É basicamente o nível de acesso e edição do usuário que está tentando conectar.
SOLUÇÃO:
1 - Eu baixei o PipefyConnector (PipefyConnector.mez_1_1_2_ ) e acessei o arquivo PipefyConnector.mez. Os arquivos .mez são compactações, então você pode acessa-lo através de qualquer software de compactação, em meu caso usei o 7-zip. (Clique com o botão direito no arquivo > Abrir como > Procurar o 7-zip File Manager no computador)
2 - Serão exibidos os arquivos do connector. Procure o arquivo Pipefy.m, clique com o botão direito e em Editar.
3 - O arquivo deve ser aberto pelo notepad. Pesquise dentro do arquivo (Ctrl + F) a seguinte linha:
response_type = "code",
Você deve achar o bloco
AuthorizeUrl = "https://app.pipefy.com/oauth/authorize?" & Uri.BuildQueryString(/
client_id = client_id,
state = state,
response_type = "code",
scope= "read",
redirect_uri = redirect_uri])
4 - Insira seguinte recho abaixo de response_type = "code", :
scope= "read",
O bloco todo ficará assim:
AuthorizeUrl = "https://app.pipefy.com/oauth/authorize?" & Uri.BuildQueryString(r
client_id = client_id,
state = state,
response_type = "code",
scope= "read",
redirect_uri = redirect_uri])
Com isso, você está enviando o scope indicado no erro como necessário. Basta salvar o arquivo. O 7-zip deve pedir uma confirmação para atualiza-lo. E seguir o restante dos passos para configuração do Conector.
Em meu caso, o escopo de leitura (read) funcionou normalmente!
Espero ter ajudado!
Abraços
Hello
I am loggin in the aplication whit my email and pasword, but this is the error now
Could you help me please?

Buen dia.
Pudimos arreglar el login ajustando la URL de login de la siguiente manera
Original:
*&response_type=code&redirect_uri=https%3A%2F%2Foauth.powerbi.com%2Fviews%2Foauthredirect.html
Ajuste:
*&response_type=code&scope=read+write&redirect_uri=https%3A%2F%2Foauth.powerbi.com%2Fviews%2Foauthredirect.html
Hola Paola, esa URL en qué parte la ajustas? Es alguna opción en el PowerBI o en el conector mismo?
I am not using a URL that I can change. When I open powerBI I press Get Data » more » Pipefy (Beta). Then a pop up opens up to sign in which I added a picture of before. I’m not “using” any URL and I cannot change the url of the verification page that pops up. In the picture I sent though you can see the URL that the pop up uses.
I have tried however to go into the browser and log in at the URL, as suggested by Paola
Which let me log in fine, but did nothing for my ability to log in within PowerBI.
Hi
Can you share with me the URL that you are using for authentication, please?
Hi
Also

Has anyone been able to get past this “missing parameter” error?
I would really appreciate the help.
Hello
I am loggin in the aplication whit my email and pasword, but this is the error now
Could you help me please?

Buen dia.
Pudimos arreglar el login ajustando la URL de login de la siguiente manera
Original:
*&response_type=code&redirect_uri=https%3A%2F%2Foauth.powerbi.com%2Fviews%2Foauthredirect.html
Ajuste:
*&response_type=code&scope=read+write&redirect_uri=https%3A%2F%2Foauth.powerbi.com%2Fviews%2Foauthredirect.html
Hi
To speed up the solution I recommend to contat our suport team throught the chat inside the plataform and they will help you with this!
Anyway Im looking for update this post to avoid this error for future.
Hi Lais,
Thank you so much - but unfortunately I got the same error. I tried a few things (restarting; restarting PowerBI; replacing connector at differing points etc) but no luck. Any ideas? (Sorry!)
:)
Hi
Can you try using this one I attached here, please?
Let me know if it doesn't work, please.
Hi All
I have been completely unable to log in using the connector, eventually getting an error that stops me from even trying anything else (looks like Paola-Cuellar error posted above). Has anyone else had this issue? Our company uses SSO (Single Sign On) so I don’t actually have an email address and password to enter; is there a solution around this someone can share?
Thanks
Amanda :)
Hello
I was having the same problem and I was able to fix it. See the steps below:
- Download the updated Pipefy connector here (thank you
@consultoria24 for providing this) - Follow all the steps on the PDF above until you reach on the login page
- Instead of using you login credentials, you will use a GRAPH QL API code
- Enter in your Pipefy account
- Go to Account Preferences → Personal Access Token
- Click Generate New Token
- Copy the token and paste it on the Account Key
- Enjoy!
After that, you just need to select the databases you want to import.
Hope it helps!
Best Regards,
Kelwin
Hello
I am loggin in the aplication whit my email and pasword, but this is the error now
Could you help me please?

Hola
Buen dia.
Me podrian indicar donde se debe crear la carpeta para guardar la extension?
Does anyone know why this error appears after entering the organization id when connecting power bi with pipefy?

I have a copy of the connector saved on my drive.
Link: https://drive.google.com/drive/folders/1Zm5L98mw2YBxw9BhXVh-0h09f-VdsO1Y?usp=sharing
Thx
I have a copy of the connector saved on my drive.
Link: https://drive.google.com/drive/folders/1Zm5L98mw2YBxw9BhXVh-0h09f-VdsO1Y?usp=sharing
Cant download connector?
Hi Emily, there is a PowerBi connector that we build (not a native feature of Pipefy, therefore we don't offer support to enable this integration). Please find below two helpful links for that:
Someone know how to creat the gateway of this pipefy conector beta to power bi online?
Currently, I am using pwbi using the connector and to automate the sync daily I installed the Gateway. It is working perfectly. The connector has some limits when dealing with huge amount of rows, but most of the case we do not reach it. Additionally, we developed a middleware that uses Pipefy APIs and store data into a MariaDB in our Google Cloud environment. We created a VM for it. We also replicated this scenario for a customer which is integrating Pipefy data with other applications and the main database (customers) is located in an proprietary system (no API available).
Reply
Join us in the Pipefy Community! 🚀
No account yet? Create an account
Login with your Pipefy credentials
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.