User Tools

Site Tools


microsoft_power_bi

This is an old revision of the document!


Getting your data into Microsoft Power BI

Powerbi Desktop

  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 and paste your API key

Amazon MWS

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.

microsoft_power_bi.1622685442.txt.gz · Last modified: 2021/06/03 02:57 by windsor_ai