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/06/03 02:51]
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.
  
-====== Powerbi Desktop ====== 
  
-  - Download the template from our template page [[https://www.windsor.ai/template-gallery/]] +How to get facebook data into powerbi
-  - Follow the steps on the Registration page. Register to Windsor.ai on[[https://onboard.windsor.ai/register| https://onboard.windsor.ai/register]] +
-  - Add your data sources in the onboarding form +
-  - Choose the "2. Select Destination" tab +
-  - Select Power BI Desktop and copy API Key +
-  - Paste your API key+
  
 +{{youtube>0uMPu90whWs?large}}
  
  
-[[https://www.windsor.ai/how-to-connect-amazon-mws-to-power-bi/|Amazon MWS]]+ 
 +{{::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 23: Line 37:
  
 {{ :power-bi_supptdlangs-locale.png?nolink&500 |}} {{ :power-bi_supptdlangs-locale.png?nolink&500 |}}
- 
- 
  
  
Line 33: 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 48: Line 60:
 {{:columns.png?800|}} {{: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.1622685110.txt.gz · Last modified: 2021/06/03 02:51 by windsor_ai