The following connector article is provided by Funnel, the owner of this connector and a member of the Microsoft Power Query Connector Certification Program. If you have questions regarding the content of this article or have changes you would like to see made to this article, visit the Funnel website and use the support channels there.
Summary
Item
Description
Release State
General Availability
Products
Power BI (Semantic models) Power BI (Dataflows) Fabric (Dataflow Gen2)
Authentication Types Supported
Funnel Workspace
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, navigate to the Microsoft Power BI page in the left navigation (if you can't see it, please 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.
Capabilities Supported
Import
Connect to Funnel from Power Query Desktop
To connect to Funnel:
Select Online Services, find Funnel from the product-specific data connector list, and then select Connect.
Select Sign in to sign in to your Funnel Workspace.
Sign in with your Google user connected to Funnel or use your Funnel credentials.
Once you've successfully signed in select Connect to continue.
In the Navigator dialog box, choose one or more Data Shares from your Workspaces to import your data.
For each Data Share you can enter number of rolling months of data you want.
Note
The default number of months is 12. If today is 22.03.2022, then you'll get data for the period 01.04.2021 - 22.03.2022.
You can then either select Load to load the data or select Transform Data to transform the data.
Known issues and limitations
If a Data Share contains too much data for one month, the connector will get a TOO_MANY_ROWS error.
Demonstrate the business value and product capabilities of Microsoft Power Platform, such as Power Apps, data connections with Dataverse, and Power Automate.