Solved

Integrate specific Pipefy reports data into Power BI

  • 4 December 2023
  • 2 replies
  • 129 views

Userlevel 1

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

icon

Best answer by Lucas Democh 8 December 2023, 16:56

View original

2 replies

Userlevel 7

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


Let me know if you need anything else!

Userlevel 7
Badge +15

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. 

Reply