Power BI

Under Review

Add shopify data

Vote (117)

Neil Vaidya on 28 Jan 2015 02:42:27

Administrator on 28 Jan 2015 06:11:51

Thanks Neil! Shopify is a really interesting data source! Is anyone else out there using it? Please add your votes if you think we should prioritize this!

Comments (25)

Comments (25)

Hannah Jacka on 05 Jul 2020 23:06:36

RE: Add shopify data

Are we any closer to this? I already pay for access to Power BI and currently the apps available are another paid source. with 18 shopify stores i need data from this is not ideal

Ezzie Goldish on 05 Jul 2020 23:05:28

RE: Add shopify data

Please add this capability... many companies use Shopify, and the ability to pull that data into Power BI would be tremendous.

Matt Jackman on 05 Jul 2020 22:59:55

RE: Add shopify data

Hi all, not sure if you get these updates, but you can quite easily do this via the Shopify Private App.

1) Create a private app in Shopify (bottom of Apps page there's a link to 'manage private apps')

2) Create the app by following the on screen instructions. You'll want to grant access to whichever data you're looking for.

3) You'll be presented with the API Key and Password (you'll need these later).

4) Create the json HTTPS URL that you'll use to retreive the data. e.g. https://{API_KEY}:{PASSWORD}@{STORE_NAME}.myshopify.com/admin/orders.json

Visit https://help.shopify.com/api/reference for possible requests and parameters.

5) Create a new Web data connection in Power BI and paste your URL from step 4.

6) You'll need to use Authentication on this, so select Basic authentication and enter the API Key in the Username field and the API Password in the Password field.

6) You'll now be connected, but just need to transform the data. Click on the 'List' link in the 2nd column header of the result and then on then in the top left corner you'll see 'To Table'. Click 'To Table' and it'll present you with the columns available in your data set.

From there you should be sweet.

Hasan on 05 Jul 2020 22:54:54

RE: Add shopify data

This will be great. I am keep going to IT to bring the Shopify data to SQL. I would like to do it on my own.

Vitalii Efremov on 05 Jul 2020 22:30:40

RE: Add shopify data

Today we are excited to announce the release of the Power BI Connector for Shopify!

https://apps.shopify.com/power-bi-connector

If you have any questions, feel free to send an email. We are here to help you get started and happy to answer any questions!