Facebook Ads Connector for Power BI

💡
Click here to download the Facebook Ads Connector for Power BI.
This page explains how to install and use the Facebook Ads Connector for Power BI.
The connector is an early-release preview for customer feedback. It is free to use during this preview period.

Installing the connector

  1. Download and run the installer for the Facebook Ads connector for Power BI. The installer requires administrative rights on your machine in order to successfully complete.
  1. Microsoft Defender Smart Screen may block the installer. If you see this screen, click More Info then Run anyway to continue.
notion image
notion image
Follow the prompts to install the connector.
Once the connector has been installed, it will now be available to you in the Get Data screen in Power BI:
notion image

Signing in to the connector

When you first use the connector, you will be prompted to authenticate:
  1. First, you will authenticate to SyncWith using a Microsoft Online or Azure Active Directory account.
  1. Next, you will authenticate to Facebook to enable SyncWith to import data from your Facebook accounts.
  1. Once you have connected your desired Facebook accounts, you will return to Power BI.
These screenshots show the process from start to finish:
1. Open the Get data dialog
2. Search for facebook ads to find the Facebook Ads connector
notion image
3. Click Connect
4. You may see a warning that the connector is in Beta mode. Click Don't warn me again for this connector, then click Continue.
notion image
5. Power BI will prompt you to sign in to SyncWith. Click Sign in.
notion image
6. Power BI will pop up a browser window so that you can sign in to SyncWith. Sign in using your Microsoft Online or Azure Active Directory account.
notion image
7. After signing in, you will be prompted to authorize SyncWith to access your Facebook data. Click Connect a Facebook Account.
notion image
8. When prompted, click Continue:
notion image
9. Click Next as required by the Facebook wizard. On the final screen, click Done.
notion image
10. Click OK when prompted:
notion image
11. Click Return to Power BI (or connect additional Facebook accounts, if desired):
notion image
12. Power BI will confirm that you are now signed in. Click Connect:
notion image

Using the connector

Use the Get data menu to open the connector. You will see the navigator, where you can pick which Facebook accounts to import. You can also choose what granularity of data to import (account, campaign, ad set or ad), as well as which breakdowns to import (age, gender, country, etc).
In this screenshot, we’re showing:
  • Data for Spool & Spindle
  • …aggregated at the Account level
  • …not broken out by any demographic breakdowns
  • …with daily granularity
  • …for the last 30 days
notion image
Once you’ve picked the datasets you want to load, you can then use all of Power BI’s standard features to manipulate and visualize the data.
We hope you find our Facebook Ads Connector for Power BI helpful — if you have any feedback, please let us know by email to hello@syncwith.com.
💡
Click here to download the Facebook Ads Connector for Power BI.