This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
microsoft_power_bi [2021/07/20 06:31] windsor_ai |
microsoft_power_bi [2023/03/02 13:09] windsor_ai |
||
---|---|---|---|
Line 3: | Line 3: | ||
===== Getting started with Power BI Desktop and Windsor.ai ===== | ===== Getting started with Power BI Desktop and Windsor.ai ===== | ||
- | - Download any Power BI Desktop template from our [[https://www.windsor.ai/ | + | - Ordered List Item Connect your datasources at https://onboard.windsor.ai/ |
- | - Go to the Registration | + | - Select your fields on the destination |
- | - Add your data sources in the onboarding | + | - In Power BI select " |
- | - Choose the "2. Select Destination" | + | |
- | - Select Power BI Desktop and copy API Key | + | |
- | - Go back to Power BI Desktop and paste your API key | + | How to get facebook data into powerbi |
+ | |||
+ | {{youtube> | ||
+ | |||
+ | |||
+ | |||
+ | {{:: | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | {{youtube> | ||
+ | |||
+ | |||
+ | |||
+ | |||
===== How to connect Amazon MWS? ===== | ===== How to connect Amazon MWS? ===== | ||
Line 28: | Line 45: | ||
{{: | {{: | ||
- | 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 |
{{: | {{: | ||
Line 47: | 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: | 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: | ||
- | - Have the Power BI Desktop file open and in Report View | + | - Power BI click "Get data" from WEB and copy paste the API URL then click on **Advanced** |
- | - Click on the arrow for "Edit Queries" | + | - Increase |
- | - A dropdown will appear - then click "Data Source Settings" | + | |
- | - Data source settings pop-up window | + | {{: |
- | - Click on " | + | |
- | - Another pop-up will appear | + | ===== Working with date ranges (absolute and relative) ===== |
- | - Click on Advanced Options (a drop-down | + | |
- | | + | === Relative date ranges === |
- | - 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 | + | When you finish building your query you will see a URL like this: |
+ | |||
+ | |||
+ | {{ : | ||
+ | < | ||
+ | |||
+ | Now < | ||
+ | |||
+ | Valid values for relative date ranges are: | ||
+ | |||
+ | | ||
+ | * 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 | ||
+ | |||
+ | |||
+ | {{ : | ||
+ | |||
+ | |||
+ | < | ||
+ | |||
+ | Will load the date range < | ||
+ | |||
+ | To only set a start date and default to todays date as end date you would just omit the < | ||
+ | |||
+ | < |