• Pulling data from charts.windsor.ai

1. Download the template from our template page https://www.windsor.ai/template-gallery/
2. Go to the Registration page and register to Windsor.ai on https://onboard.windsor.ai/register
3. Add your data sources in the onboarding form
4. Choose the “2. Select Destination” tab
5. Select Power BI Desktop and copy API Key
6. Go back to Power BI Desktop and paste your API key

Amazon MWS

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)

1. Click explore chart

2. Select the fields you want and click CSV to get the URL for the data-feed

3. Add this URL to powerbi. It works as a data-feed.

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.

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:

1. Have the Power BI Desktop file open and in Report View
2. Click on the arrow for “Edit Queries” (in the External Data section)
3. A dropdown will appear - then click “Data Source Settings”
4. Data source settings pop-up window will appear
5. Click on “Change Source…”
6. Another pop-up will appear
7. Click on Advanced Options (a drop-down of sorts will appear within the pop-up)
8. “Command timeout in minutes (optional)” will be the first option
9. Enter a value - I chose to enter 60 minutes but feel free to enter any value
10. Then apply the query changes and wait till the refresh is complete