====== Getting your data into Microsoft Power BI ======

===== Getting started with Power BI Desktop and Windsor.ai =====

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


How to get facebook data into powerbi

{{youtube>0uMPu90whWs?large}}



{{::powerbi_get_data.png?800|}}





{{youtube>6xJDClsnhzQ?large}}






===== How to connect Amazon MWS? =====

This article here [[https://www.windsor.ai/how-to-connect-amazon-mws-to-power-bi/|Connect Amazon MWS to Power BI]] contains all instructions.

===== Why are my numbers multiplied in Power BI desktop? =====

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)

{{ :power-bi_supptdlangs-locale.png?nolink&500 |}}


===== Pulling data from charts.windsor.ai =====

1. Click explore chart

{{:powerbi_facebook.png?800|}}

2. Select the fields you want and click JSON to get the URL for the data-feed

{{:powerbi_facebook_advertising_data.png?800|}}

3. Add this URL to powerbi. It works as a data-feed.




===== Adding new fields to the Source statement =====

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.

{{:columns.png?800|}}

===== Increasing the default timeout in Power BI =====

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:

  - Power BI click "Get data" from WEB and copy paste the API URL then click on **Advanced**
  - Increase the **Command timeout in minutes** setting:

{{:power_bi_timeouts.png?600 |}}

===== Working with date ranges (absolute and relative) =====

=== Relative date ranges ===

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


{{ :date_ranges_power_bi.jpg?900 |}} \\
<code>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</code>

Now <code>&date_range=last_7d</code> 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.

=== Absolute date ranges ===

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


{{ :date_ranges_power_bi_2.jpg?900 |}} 


<code>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</code>

Will load the date range <code>&date_from=2023-01-17&date_to=2023-01-24</code>. 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:

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