Data pipeline provides a Database (Redshift) with all you Pipefy’s data, where you can query and analyze inside any BI tool. We don’t offer a native connector to the Data pipeline, but you can use the Redshift connector inside Power BI Desktop or in other BI tools to connect to your Data pipeline instance.
The following tutorial assumes that you have a valid Data pipeline subscription and you already received the credentials from the Pipefy team.
Select Get Data – > Database -> Amazon Redshift connector
Provide Server and database details and choose Direct Query in the data connectivity mode.
Provide your username, password and click Connect
Power BI Navigator window shows the available tables that you have access to, Select Edit for data shaping and transformations or select Load to import data of selected tables/views to the Power BI desktop.
For more information regarding the tables, fields, and data available, check this help article.