Versions Compared

Version Old Version 16 New Version Current
Changes made by

Liliia Ostrovska

Liliia Ostrovska

Saved on

Key

  • 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
minLevel1
maxLevel7

How to Use Power BI

Templates

Template

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

Create from template.gifImage Removedpbi-connector-for-shopify-by-tempo-pbi_dashboard_template-1.gifImage Added

  1. Select Create datasource.

Create datasource.gifImage Removedpbi-connector-for-shopify-by-tempo-pbi_dashboard_template-2.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 Removedpbi-connector-for-shopify-by-tempo-pbi_dashboard_template-3-5.gifImage Added

  1. Select Next.

Info

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

Next.gifImage Removedpbi-connector-for-shopify-by-tempo-pbi_dashboard_template-6.gifImage Added

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

File.gifImage RemovedFile.gifImage Added

  1. Select Import, and then Power BI template.

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

Import - Power BI template.gifImage RemovedImport - Power BI template.gifImage Added

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

Copy URL.gifImage Removedpbi-connector-for-shopify-by-tempo-pbi_dashboard_template-10.gifImage Added

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

Input_URL.gifImage RemovedInput_URL.gifImage Added

  1. Select the Basic authentication.

Basic authentication.gifImage RemovedBasic authentication.gifImage Added

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

Settings.gifImage Removedpbi-connector-for-shopify-by-tempo-pbi_dashboard_template-13.gifImage Added

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

Credentials.gifImage Removedpbi-connector-for-shopify-by-tempo-pbi_dashboard_template-14.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.gifImage RemovedUser name and password.gifImage Added

  1. Select Connect.

Connect-2.gifImage RemovedConnect-2.gifImage Added

Info

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

Power BI Dashboard

Templates

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