Getting your data into Microsoft Power BI

1. Ordered List Item Connect your datasources at https://onboard.windsor.ai/
2. Select your fields on the destination page
3. In Power BI select “Get data” from WEB and paste the URL from the onboard form.

If your PC is on a non English locale, it can happen that values are multiplied. A western European locale would for example format the number 1.00 wrongly as it would expect the number to look like this: 1,00. You will need to change the locale in the Power BI settings to English (United States)

To be able to add new fields to the existing report, you need to remove the parameter “Columns=nnn” from the Source statement in Advanced Editor in Power BI Desktop.

In case you have issues with loading longer date ranges it can be caused by timeouts. To change the default timeout please follow the steps below:

1. Power BI click “Get data” from WEB and copy paste the API URL then click on Advanced
2. Increase the Command timeout in minutes setting:

When you finish building your query you will see a URL like this:

https://connectors.windsor.ai/all?api_key=[API_KEY]&date_preset=last_7d&fields=account_name,campaign,clicks,datasource,date,order_name,sessions,source,spend&_renderer=powerbi

Now

&date_range=last_7d

means that you are working with a relative date range of 7 days.

Valid values for relative date ranges are:

• last_1d
• last_3d
• last_7d
• last_14d
• last_28d
• last_30d
• last_90d
• last_180d
• this_month
• last_year

You can change the values accordingly to change the relative date range.

To work with absolute (fixed) date ranges you can select a date range in the date range picker

https://connectors.windsor.ai/facebook?api_key=[API_KEY]&date_from=2023-01-17&date_to=2023-01-24&fields=account_name,campaign,clicks,date,spend&_renderer=powerbi

Will load the date range

&date_from=2023-01-17&date_to=2023-01-24

. You can now manually modify this to adjust your query.

To only set a start date and default to todays date as end date you simply just remove the date_to from the URL. The query then would look like this:

https://connectors.windsor.ai/facebook?api_key=[API_KEY]&date_from=2023-01-17&fields=account_name,campaign,clicks,date,spend&_renderer=powerbi