Differences

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

--- microsoft_power_bi [2021/08/24 14:27]
windsor_ai
+++ microsoft_power_bi [2024/11/19 13:45] (current)
windsor_ai
@@ Line 6: / Line 6: @@
   - Select your fields on the destination page
   - In Power BI select "Get data" from WEB and paste the URL from the onboard form.
-{{::powerbi_get_data.png?800|}}
+===== Why are my numbers multiplied in Power BI desktop? =====
+If your PC is on a non English locale, it can happen that values are multiplied. A western European locale would for example format the number 1.00 wrongly as it would expect the number to look like this: 1,00.
+You will need to change the locale in the Power BI settings to English (United States)
- [m]<HTML> [m]
+{{ :power-bi_supptdlangs-locale.png?nolink&500 |}}
-<iframe width="560" height="315" src="https://www.youtube.com/embed/6xJDClsnhzQ" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>
- [m]<HTML> [m]
-===== 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? =====
+===== Adding new fields to the Source statement =====
-If your PC is on a non English locale, it can happen that values are multiplied. A western European locale would for example format the number 1.00 wrongly as it would expect the number to look like this: 1,00.
+To be able to add new fields to the existing report, you need to remove the parameter "Columns=nnn" from the Source statement in Advanced Editor in Power BI Desktop.
-You will need to change the locale in the Power BI settings to English (United States)
-{{ :power-bi_supptdlangs-locale.png?nolink&500 |}}
+{{:columns.png?800|}}
+===== Increasing the default timeout in Power BI =====
-===== Pulling data from charts.windsor.ai =====
+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:
-. Click explore chart
+  - Power BI click "Get data" from WEB and copy paste the API URL then click on **Advanced**
+  - Increase the **Command timeout in minutes** setting:
-{{:powerbi_facebook.png?800|}}
+{{:power_bi_timeouts.png?600 |}}
-. Select the fields you want and click CSV to get the URL for the data-feed
+===== Working with date ranges (absolute and relative) =====
-{{:powerbi_facebook_advertising_data.png?800|}}
+=== Relative date ranges ===
-. Add this URL to powerbi. It works as a data-feed.
+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.
-===== Adding new fields to the Source statement =====
+Valid values for relative date ranges are:
-To be able to add new fields to the existing report, you need to remove the parameter "Columns=nnn" from the Source statement in Advanced Editor in Power BI Desktop.
+  * last_1d
+  * last_3d
+  * last_7d
+  * last_14d
+  * last_28d
+  * last_30d
+  * last_90d
+  * last_180d
+  * this_month
+  * last_year
-{{:columns.png?800|}}
+You can change the values accordingly to change the relative date range.
-===== Increasing the default timeout in Power BI =====
+=== Absolute date ranges ===
-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:
+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:
-  - Have the Power BI Desktop file open and in Report View
+<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>
-  - Click on the arrow for "Edit Queries" (in the External Data section)
-  - A dropdown will appear - then click "Data Source Settings"
-  - Data source settings pop-up window will appear
-  - Click on "Change Source..."
-  - Another pop-up will appear
-  - Click on Advanced Options (a drop-down of sorts will appear within the pop-up)
-  - "Command timeout in minutes (optional)" will be the first option
-  - 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

Knowledge Base

User Tools

Site Tools

Differences

Page Tools