Differences

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

--- microsoft_power_bi [2022/10/27 13:05]
windsor_ai
+++ microsoft_power_bi [2023/03/02 13:09]
windsor_ai
@@ Line 64: / 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:
-  - Power BI click "Get data" from WEB and copy paste the API URL then click on advanced
+  - Power BI click "Get data" from WEB and copy paste the API URL then click on **Advanced**
-  - Increase the Command timeout in minutes setting:
+  - 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 would just omit the <code>&date_from=2023-01-24</code> part of the query so 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>

Knowledge Base

User Tools

Site Tools

Differences

Page Tools