Edit

Set up your Funnel connection

This article outlines the steps to create a Funnel connection.

Supported authentication types

The Funnel connector supports the following authentication types for copy and Dataflow Gen2 respectively.

Authentication type Copy Dataflow Gen2
Funnel Workspace n/a √

Set up your connection for Dataflow Gen2

You can connect Dataflow Gen2 in Microsoft Fabric to Funnel using Power Query connectors. Follow these steps to create your connection:

  1. Check capabilities to make sure your scenario is supported.
  2. Complete prerequisites for Funnel.
  3. Get data in Fabric.
  4. Connect to Funnel data.
  5. Check limitations and considerations for any current restrictions.

Capabilities

  • Import

Prerequisites

To use the Funnel connector, you need a Funnel subscription. Funnel helps you collect data from all your marketing platforms, transform it, and send it to the destinations you want, like Power BI (https://funnel.io/).

In the Funnel App, go to your Workspace and navigate to the Microsoft Power BI page in the left navigation (if you can't see it, contact us). Follow the instructions on the page. You need to create a "Data Share" that contains the fields you want to expose in Power BI.

Get data

To get data in Data Factory:

  1. On the left side of Data Factory, select Workspaces.

  2. From your Data Factory workspace, select New > Dataflow Gen2 to create a new dataflow.

    Screenshot showing the workspace where you choose to create a new dataflow.

  3. In Power Query, either select Get data in the ribbon or select Get data from another source in the current view.

    Screenshot showing the Power Query workspace with the Get data option emphasized.

  4. In the Choose data source page, use Search to search for the name of the connector, or select View more to the right of the connector list to see all the connectors available in Data Factory.

    Screenshot of the Data Factory Choose data source page with the search box and the view more selection emphasized.

  5. If you choose to view more connectors, you can still use Search to search for the name of the connector, or choose a category to see a list of connectors associated with that category.

    Screenshot of the Data Factory Choose data source page displayed after selecting view more, with the list of connectors.

Connect to Funnel data

To connect to Funnel data:

  1. Select Funnel from the Power Query Connect to data source page.

  2. Select Sign in to sign in with your Google account or Funnel credentials.

  3. Once you successfully sign in, select Next.

  4. In the Choose data page, select the Data Shares you want to load from your Funnel workspace, and then select Transform data to transform the data in Power Query Editor.

Limitations and considerations

  • If a Data Share contains too much data for one month, the connector gets a TOO_MANY_ROWS error.

For more information, read our Power BI knowledge base articles.

Set up your connection in a pipeline

Data Factory in Microsoft Fabric doesn't currently support Funnel in pipelines.

Related content

  • Last updated on