Add shopify data

[neil21]

NULL

[justin24]

PLEASE!!!!!!!

[info140]

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!

[hasan_arslan]

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.

[t_matt_jackman]

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.

[ezzie_goldish1]

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

[hannah_jacka]

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

[gmisselhorn]

Absolutely please add this. Would be high value to all Shopify stores.

[andy61]

To Matt Jackman - Thanks for sharing your notes. Can you share some more about how you're using the data? Do you have a bog?

[sunny5]

I would love it if there was a native shopify connector

[fbcideas_migusr]

What Matt Jackman wrote below works a treat, thanks for that tip!!!