1. Being signed in to your Shopify account, select Apps, and then select Alpha Serve Power BI Connector.

Apps - Alpha Serve Power BI Connector.gif

  1. Select New data source.

Create Data Source.gif

  1. In the Name field, enter the data source name.

  2. In the Description field, enter the description of your data source.

Name and Description.gif

  1. [Optional] If needed, schedule automatic data update.

There are 4 possible options in the Scheduler menu.

  • Disabled - in this case, you will be able to update this data source manually when needed;

  • Continuous - in this case, the data source with this schedule type will be updated constantly. The data preparation process will start after the previous one is completed.

  • Every day - in this case, the data source will be updated every day at the selected time.

  • Weekly - in this case, the data source will be updated only once a week on the selected day and time.

The Scheduler menu depends on your subscription plan.

Scheduler.gif

  1. Select all fields and filters you need.

Field and filters.gif

On the left, you can see tabs with all data types available for export. Each tab contains the corresponding tables and fields that you can select. This helps you navigate easily among numerous tables and data types.

Learn the Entity-Relationship Diagram to understand all the connections and correlations between tables.

Check information about the data types supported by the Power BI Connector here.

Sections.gif

Filters allow you to limit data based on several criteria, so your BI app does not need to get a complete list of results and then parse through it on its own.

Filter Options.gif

You can combine multiple filters for data.

Multiple fields.gif

  1. When everything is done, select Save.

Save.gif

  1. Go back to the Data sources page.

After the successful creation of a data source, you have to prepare it for export.

Return to Data Sources page.gif

The newly-created data source has the status.

NOT READY (1).gif

  1. Select Generate.

Generate.gif

The status will be changed to , and then to .

PENDING.gif

Shopify allows you to prepare only one data source at a time. Therefore, if several sources are being prepared, they queue up one after the other.

IN PROGRESS.gif

Once the status is , it means you can start exporting your data.

If you make some changes to your data source, its status will become again.

How to export Shopify data into Microsoft Power BI.

Data Source Statuses Overview

The data source has several statuses:

  • indicates that the data source has just been created and is not ready for export.

  • is activated when selecting the Generate button. The status indicates that the system is preparing to create a data source snapshot.

  • indicates that the snapshot is being created for your data source. It will be valid for export for 7 days after generating a snapshot.

  • indicates the readiness of your data source to be exported.

  • indicates that the snapshot is expired and you need to regenerate it.

When you generate the snapshot of your data source, two additional fields appear:

  • Prepared at that displays the date and time when the data source snapshot was generated.

  • Expires at that displays the date and time when the data source snapshot will expire (the snapshot is valid for 7 days after its generating).

prepared-and-expire.gif

If you use automatic data update, the data source snapshot will be constantly valid, and the Expires at field will display Never.

expiration-date.gif

The speed of data preparation depends on the amount of data you’ve selected. Most data sources preparation takes a few minutes. But sometimes this can take even hours, for example, if there are thousands of rows to be prepared.

To speed up data preparing process:

  • Apply filters to reduce queried data.

  • Try removing some fields from your query so that preparing can run faster.

  • Break up the data source into smaller parts.

If you need assistance with it, please, contact our Support team.