Can I integrate Pipefy and PowerBi?

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([
            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
 

paola-cuellar wrote:

paola-cuellar wrote:

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?

@Lais Laudari 

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

https://app-auth.pipefy.com/login?afterLoginRedirectTo=*&response_type=code&scope=read+write&redirect_uri=https%3A%2F%2Foauth.powerbi.com%2Fviews%2Foauthredirect.html

Which let me log in fine, but did nothing for my ability to log in within PowerBI.

Hi @jorden-monroe !
Can you share with me the URL that you are using for authentication, please?

Hi @Lais Laudari @paola-cuellar @kelwin-silva . I am also running into this issue. I don’t quite understand the GraphQL API Token answer. I understand how to get the token and how to use it in things like python script. But in this case the “pop up” inside PowerBI where you login to Pipefy is not in a browser, and only gives you the ability to input your organization id, then email and password. After which you get this page(below). Where do I put the API token?

Also @paola-cuellar what do you mean by adjusting the login URL? The PowerBI connector login for pipefy is in a pop up with no URL to adjust. I tried to go into my browser and add your endpoint and login from there, and it let me, but I still run into the same error signing in from inside of PowerBI.

Has anyone been able to get past this “missing parameter” error?

I would really appreciate the help.

paola-cuellar wrote:

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

@AmandaK can you share with me the URL that you are using for authentication, please?

Hi @AmandaK!
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 @AmandaK!
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 @paola-cuellar !

I was having the same problem and I was able to fix it. See the steps below:

1. Download the updated Pipefy connector here (thank you @consultoria24 for providing this)
2. Follow all the steps on the PDF above until you reach on the login page
3. Instead of using you login credentials, you will use a GRAPH QL API code
4. Enter in your Pipefy account
5. Go to Account Preferences → Personal Access Token
6. Click Generate New Token
7. Copy the token and paste it on the Account Key
8. 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 @paola-cuellar , creo que este archivo te ayudará con este problema, si aún tienes preguntas, ¡envíalas aquí! 😉
 

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?

Thx

@Cesar Backes - Stella 

I have a copy of the connector saved on my drive.

Link: https://drive.google.com/drive/folders/1Zm5L98mw2YBxw9BhXVh-0h09f-VdsO1Y?usp=sharing

@Cesar Backes - Stella mail me at: sartoritobias14@gmail.com

Cant download connector?

@lais-laudari HERE

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).

@vitoria_lanes, we can test to see if it works for us