Our Power BI Connector makes it easy for you to access all your Funnel data directly from Power BI Desktop. You need the November 2024 version of Power BI Desktop for this to work. You can download the latest version here.
Setup in Funnel
Navigate to the Export page
Create a new Power BI Export that contains the fields you want to have in Power BI
Please Note: The Power BI connector does not support formula calculated fields.
Connect from Power BI Desktop
Open Power BI Desktop
Click Get data
Search for Funnel
Click Connect
Log in with your Funnel user
In the Navigator dialog box, choose one or more Exports from your Workspaces to import your data
(Optional) Enter the number rolling months of historical data to import (defaults to 12)
Select Load or Transform data
The Data Share will now show up as a table in Power BI Desktop
You now have your marketing data in Power BI!
FAQ
Why am I getting 12 times more data than expected?
Why am I getting 12 times more data than expected?
This happens when importing data from Funnel that has been imported to Funnel without attributing the data to a date. Because the connector imports data in one month batches and new connections default to 12 month rolling date interval, the dateless data is fetched 12 times.