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