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? )
Integrate specific Pipefy reports data into Power BI
HI
I think these topics would help you:
Â
Let me know if you need anything else!
Hi
Â
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
Join us in the Pipefy Community! 🚀
No account yet? Create an account
Login with your Pipefy credentials
or
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.