User Guide

You must have the relevant Shopify account permissions to follow the instructions on this page.

Check Shopify Help Center for more information.

 

How to Export Data from Shopify to Microsoft Power BI

 

1. Create Data Source

 

Initially, you need to create a data source for data you want to export from your Shopify store to your Microsoft Power BI. You can do it by accessing the Data source page inside the Power BI Connector for Shopify.

You have to name your data source, adjust auto-refresh, and filter the tables you’d like to be in your data source.

If you need more information on how to create a data source, please refer to our step-by-step instruction.

Create Data Source.gif

 

2. Export Shopify Data into Microsoft Power BI

 

After creating a data source, you can easily export your data into Microsoft Power BI. Being on the Data source page, select Copy URL. Launch your Microsoft Power BI, authorize, connect, and start working with your data.

If you need more information on how to export data, please refer to our step-by-step guide.

Copy URL.gif
https://www.alphaservesp.com/blog/power-bi-shopify-integration/