User Tools

Site Tools


microsoft_power_bi

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
microsoft_power_bi [2021/04/08 09:33]
windsor_ai
microsoft_power_bi [2023/03/02 13:10] (current)
windsor_ai
Line 1: Line 1:
 ====== Getting your data into Microsoft Power BI ====== ====== Getting your data into Microsoft Power BI ======
  
-  * [[microsoft_power_bi|Pulling data from charts.windsor.ai]]+===== 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.
  
-[[https://www.windsor.ai/how-to-connect-amazon-mws-to-power-bi/|Amazon MWS]]+ 
 +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? ===== ===== Why are my numbers multiplied in Power BI desktop? =====
Line 11: Line 36:
 You will need to change the locale in the Power BI settings to English (United States) You will need to change the locale in the Power BI settings to English (United States)
  
-{{ :power-bi_supptdlangs-locale.png?nolink&600 |}} +{{ :power-bi_supptdlangs-locale.png?nolink&500 |}}
- +
  
  
Line 22: Line 45:
 {{:powerbi_facebook.png?800|}} {{:powerbi_facebook.png?800|}}
  
-2. Select the fields you want and click CSV to get the URL for the data-feed+2. Select the fields you want and click JSON to get the URL for the data-feed
  
 {{:powerbi_facebook_advertising_data.png?800|}} {{:powerbi_facebook_advertising_data.png?800|}}
  
 3. Add this URL to powerbi. It works as a data-feed. 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>
microsoft_power_bi.1617870801.txt.gz · Last modified: 2021/04/08 09:33 by windsor_ai