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
View original
HI
I think these topics would help you:
Let me know if you need anything else!
+15
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.
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
