How to Export Shopify Data into Microsoft Power BI

Owned by Liliia Ostrovska
Last updated: Jun 25, 2024 by Viktoriia Yevhrafova
3 min read

  1. Select the Copy link icon.

Copy URL.gif

 

  1. Launch your Microsoft Power BI.

  2. Select Get data, and then select OData feed.

OData feed.gif

 

  1. In the URL field, paste the copied link of your data source, and then select OK.

 

  1. Select the Basic authentication.

 

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

 

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

If necessary, you can change the default password.

 

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

 

  1. Select Connect.

 

  1. Select the table(s) you need, and then select Load.

 

After the data is loaded, you can start building graphs and dashboards based on the Shopify data.

To do this, choose the visualization type and select the data you want to see on the graph or dashboard.