Microsoft Defender Smart Screen may block the installer. If you see this screen, click More Info then Run anyway to 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:
Signing in to the connector
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 ads to 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 Continue.
5. Power BI will prompt you to sign in to SyncWith. Click Sign in.
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 Continue:
9. Click Next as required by the Facebook wizard. On the final screen, click Done.
10. Click OK when prompted:
11. Click Return to Power BI (or connect additional Facebook accounts, if desired):
12. Power BI will confirm that you are now signed in. Click Connect:
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
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.