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.
- 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.
- Microsoft Defender Smart Screen may block the installer. If you see this screen, click
Run anywayto continue.
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:
When you first use the connector, you will be prompted to authenticate:
- First, you will authenticate to SyncWith using a Microsoft Online or Azure Active Directory account.
- Next, you will authenticate to Facebook to enable SyncWith to import data from your Facebook accounts.
- 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 adsto find the Facebook Ads connector
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
5. Power BI will prompt you to sign in to SyncWith. Click
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.
7. After signing in, you will be prompted to authorize SyncWith to access your Facebook data. Click
Connect a Facebook Account.
8. When prompted, click
Nextas required by the Facebook wizard. On the final screen, click
Return to Power BI(or connect additional Facebook accounts, if desired):
12. Power BI will confirm that you are now signed in. Click
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
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 firstname.lastname@example.org.