User Tools

Site Tools


microsoft_power_bi

Getting your data into Microsoft Power BI

Getting started with Power BI Desktop and Windsor.ai

  1. Ordered List Item Connect your datasources at https://onboard.windsor.ai/
  2. Select your fields on the destination page
  3. In Power BI select “Get data” from WEB and paste the URL from the onboard form.

How to get facebook data into powerbi

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 JSON 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. Power BI click “Get data” from WEB and copy paste the API URL then click on Advanced
  2. Increase the Command timeout in minutes setting:

Working with date ranges (absolute and relative)

Relative date ranges

When you finish building your query you will see a URL like this:


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

Now

&date_range=last_7d

means that you are working with a relative date range of 7 days.

Valid values for relative date ranges are:

  • last_1d
  • 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 (fixed) date ranges you can select a date range in the date range picker

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

Will load the date range

&date_from=2023-01-17&date_to=2023-01-24

. 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:

https://connectors.windsor.ai/facebook?api_key=[API_KEY]&date_from=2023-01-17&fields=account_name,campaign,clicks,date,spend&_renderer=powerbi
microsoft_power_bi.txt · Last modified: 2023/03/02 13:10 by windsor_ai