Skip to main content
Solved

Integrate specific Pipefy reports data into Power BI


Gabriel Candido

Hello,

I would like to know if there's a way to integrate specific Pipefy report data into Power BI using M language of Power Query.

In the API reference, there are options for Report Query and Export Report. However, the Report Query only returns the report properties (ID, name, field names), and the Export Query generates a URL to download the report ( Would I still need to continue to upload it manually? )

Best answer by Lucas Democh

Hi @Gabriel Candido,

 

You can make this connection in a few ways:

- Through the customized Pipefy connector with Power BI (Available in topics shared by Lais).

- Extract the data to a cloud (AWS, CGP ETC) and connect Power BI with the cloud.

- Extract directly via M (Power Query). This last option may not work for Pipes with a large volume of data (Power BI timeout).

 

For option 2, I provide the code that I use for extraction via AWS:

 

Best regards. 

View original
Did this topic help you find an answer to your question?

2 replies

Lais Laudari

HI @Gabriel Candido!
I think these topics would help you:
 


Let me know if you need anything else!


Lucas Democh
Forum|alt.badge.img+15
  • Pipefy Legend
  • 396 replies
  • Answer
  • December 8, 2023

Hi @Gabriel Candido,

 

You can make this connection in a few ways:

- Through the customized Pipefy connector with Power BI (Available in topics shared by Lais).

- Extract the data to a cloud (AWS, CGP ETC) and connect Power BI with the cloud.

- Extract directly via M (Power Query). This last option may not work for Pipes with a large volume of data (Power BI timeout).

 

For option 2, I provide the code that I use for extraction via AWS:

 

Best regards. 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings