Differences

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

--- microsoft_power_bi [2023/02/02 14:44]
windsor_ai
+++ microsoft_power_bi [2023/03/02 13:10] (current)
windsor_ai
@@ Line 71: / Line 71: @@
 ===== Working with date ranges (absolute and relative) =====
+=== Relative date ranges ===
 When you finish building your query you will see a URL like this:
@@ Line 94: / Line 95: @@
 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
@@ Line 105: / Line 108: @@
 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>

Knowledge Base