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/07/20 06:29]
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. 
 + 
 + 
 +How to get facebook data into powerbi 
 + 
 +{{youtube>0uMPu90whWs?large}} 
 + 
 + 
 + 
 +{{::powerbi_get_data.png?800|}} 
 + 
 + 
 + 
 + 
 + 
 +{{youtube>6xJDClsnhzQ?large}} 
 + 
  
  
-===== Power BI Desktop set up ===== 
  
-  - Download the template from our [[https://www.windsor.ai/template-gallery/|Template gallery]]  
-  - Go to the Registration page and register to Windsor.ai on[[https://onboard.windsor.ai/register| Windsor.ai data onboarding]] 
-  - Add your data sources in the onboarding form 
-  - Choose the "2. Select Destination" tab 
-  - Select Power BI Desktop and copy API Key 
-  - Go back to Power BI Desktop and paste your API key 
  
 ===== How to connect Amazon MWS? ===== ===== How to connect Amazon MWS? =====
Line 31: 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|}}
Line 50: Line 64:
 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: 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:
  
-  - Have the Power BI Desktop file open and in Report View +  - Power BI click "Get data" from WEB and copy paste the API URL then click on **Advanced** 
-  - Click on the arrow for "Edit Queries" (in the External Data section+  - Increase the **Command timeout in minutes** setting: 
-  - A dropdown will appear - then click "Data Source Settings" + 
-  - Data source settings pop-up window will appear +{{:power_bi_timeouts.png?600 |}} 
-  - Click on "Change Source..." + 
-  - Another pop-up will appear +===== Working with date ranges (absolute and relative===== 
-  - Click on Advanced Options (drop-down of sorts will appear within the pop-up) + 
-  - "Command timeout in minutes (optional)" will be the first option +=== Relative date ranges === 
-  Enter a value I chose to enter 60 minutes but feel free to enter any value + 
-  Then apply the query changes and wait till the refresh is complete+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 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 (fixeddate 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.1626758994.txt.gz · Last modified: 2021/07/20 06:29 by windsor_ai