Knowledge Base

User Tools

Site Tools

Trace:
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 [2023/02/02 14:41]
windsor_ai 		microsoft_power_bi [2024/11/19 13:45] (current)
windsor_ai
Line 7: Line 7:
   - In Power BI select "Get data" from WEB and paste the URL from the onboard form.   - 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? ===== ===== Why are my numbers multiplied in Power BI desktop? =====
Line 37: Line 14:
  
 {{ :power-bi_supptdlangs-locale.png?nolink&500 |}} {{ :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. 
- 
  
  
Line 70: Line 33:
  
 ===== Working with date ranges (absolute and relative) ===== ===== Working with date ranges (absolute and relative) =====
 +
 +=== Relative date ranges ===
  
 When you finish building your query you will see a URL like this: When you finish building your query you will see a URL like this:
  
-{{:date_ranges_power_bi.jpg?600 |}} 
  
 +{{ :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> <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>
  
Line 93: Line 58:
  
 You can change the values accordingly to change the relative date range. 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 To work with absolute (fixed) date ranges you can select a date range in the date range picker
  
-{{:date_ranges_power_bi_2.jpg?600 |}}+ 
 +{{ :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> <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>
Line 102: Line 71:
 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. 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 would just omit the <code>&date_to=2023-01-24</code> part of the query so the query then would look like this:+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> <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.1675348887.txt.gz · Last modified: 2023/02/02 14:41 by windsor_ai

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
CC Attribution-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki