In this section, we'll walk through a practical example of connecting Facebook Ads data to Power BI using Windsor.ai.

Video Guide

https://mahboubyassine10.wistia.com/medias/zli6038dwe

Setup Process

1. Windsor.ai Account Setup:

• Sign up for a Windsor.ai account if you haven't already.

Marketing Data Attribution Software | Windsor.ai

• Navigate to the 'Connections' section in your Windsor.ai dashboard.
• Find and select 'Facebook Ads' from the list of available integrations.

• Follow the prompts to authenticate your Facebook Ads account. You will be redirected to login into Facebook and grant access to your ad account.

• Then click on Next to preview your data (as prompted below)

• As you can below, you are redirected to the data preview section

• Once you select your data source, you will be able to select your requested fields for your analysis (1), and preview the final output (2). After that, you have to click on the Power BI Desktop data destination (3)

• Finally, make sure to copy the URL below. This is crucial as you will be using it to make an API call to import your data directly from Power Query.