Power BI

Under Review

Add shopify data

Vote (115)

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 (23)

Comments (23)

2c0c8fa5 9196-448b-8475-2b1f7556b6f0 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.

bbbda08e cb79-4031-b140-771ce46481d1 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.

18cadb4a dc59-4555-8ac9-a00c6ef3ffa3 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!