User Tools

Site Tools


microsoft_power_bi

This is an old revision of the document!


Getting your data into Microsoft Power BI

Getting started with Power BI Desktop and Windsor.ai

  1. Download the template from our Template gallery
  2. Go to the Registration page and register to Windsor.ai on Windsor.ai data onboarding
  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

How to connect Amazon MWS?

This article here Connect Amazon MWS to Power BI contains all instructions.

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)

Pulling data from charts.windsor.ai

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.

Adding new fields to the Source statement

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.

Increasing the default timeout in Power BI

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
microsoft_power_bi.1626759046.txt.gz · Last modified: 2021/07/20 06:30 by windsor_ai