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.
|Products||Power BI (Datasets)
Power BI (Dataflows)
|Authentication Types Supported||Funnel Account|
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 account, 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 "View" that contains the fields you want to expose in Power BI.
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 account.
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 views from your accounts to import your data.
For each view, you can enter number of rolling months of data you want.
The default number of months is 12. If today is 22.03.2022, then you'll get data for the period 01.04.2021 through 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 view contains too much data for one month, the connector will get a TOO_MANY_ROWS error.
For more information, read our Power BI knowledge base articles.
Submit and view feedback for