Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.

Power BI dashboard templates supported with pre-configured data sources are now available in the latest version.  We are happy to offer you the new and exciting Power BI Shopify reporting experience!

Build your first Power BI dashboard in a day with Shopify Power BI dashboard templates in Power BI Connector for Shopify from Alpha Serve!

Table of Contents

How to Use Power BI Templates

  1. Being signed in to your Shopify instance, open Power BI Connector, and then select Create from template.

Create from template.gifImage RemovedCreate from template.gifImage Added

  1. Select Create datasource.

Create datasource.gifImage RemovedCreate datasource.gifImage Added

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

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

  3. Select Next.

Name and description.gifImage RemovedName and Description (1).gifImage Added

  1. Select Next.


The dashboard template is available as .pbit file. After you select Next, the system will download it to your computer.

Next.gifImage RemovedNext.gifImage Added

  1. Launch your Microsoft Power BI, and then select File.


  1. Select Import, and then Power BI template.

  2. Select .pbit file you’ve downloaded before.

Import - Power BI template.gif

  1. Go back to the Data sources page, and then copy the URL of the data source.

Copy URL.gifImage RemovedShopify Dashboard.gifImage Added

  1. In the Input_URL field, paste the copied link, and then select Load.


  1. Select the Basic authentication.

Basic authentication.gif

  1. Go back to the Data sources page, select Menu, and then select Settings.

Settings.gifImage RemovedMenu-Settings.gifImage Added

  1. Copy these credentials one by one, and then use to authenticate to your Microsoft Power BI.

Credentials.gifImage RemovedCredentials.gifImage Added

  1. In the User name field, enter the copied Login credential.

  2. In the Password field, enter the copied Password credential.

  3. Select the lowest level to apply these settings to.

If you have several Sopify instances and have installed Power BI Connector on each of them, we recommend selecting the lowest level.

In each of those Power BI Connectors, all data source URLs begin in the same way and they differ only in hash (the set of characters at the end of the link).

If you keep the highest level (default), you will experience an error, as in this case, Microsoft Power BI will try to use your credentials from one instance to all the others.

If you have only one instance, you can keep the default level.

User name and password.gif

  1. Select Connect.



The Power BI dashboard templates will be loaded and you can start working with them.

Power BI Dashboard Templates Overview

Shopify Dashboard is a store Overview, Sales, Product, Customer, Fulfillment, Marketing, and Analytics reports. It shows the general information for the store. 

This dashboard will be useful for analyzing sales and marketing issues. It allows admins to monitor the sales, track the orders.