Forum Discussion

newbie74's avatar
newbie74
Frequent Visitor
4 years ago
Solved

Unable connect Shopify to Power BI

Dear community,   i don't manage to connect Power BI to my Shopify site data. In shopify, i have created a private app that generated an API key, A password and a URL containing both (note that th...
Need Help
  • newbie74's avatar
    newbie74
    4 years ago

    I have found the answer and thought i would share the exact steps.

    The Shopify API is a REST API.

     

    To get data within power BI, here are the steps in Power BI:

    1) Get DATA

    2) select WEB

    3) Enter the URL (as basic) from the private app in shopify ("https://{apikey}:{password}@{hostname}/admin/api/2021-10/orders.json")

    4) Select BASIC authentification

    5) Username is the API Key

    6) Password is the API Password

     

    And that's it, you will then get access to the data in JSON format, convert it to table, expand the records and clean the table.

     

    Many thanks

EugeneLebedev's avatar
EugeneLebedev
Icon for Helper V rankHelper V
2 years ago

Shopify is now trying to retire the Rest API in favour of the GraphQL API. I have found that coding a GraphQL API integration in M really hard. I eventually switched to this out-of-the-box solution instead - https://vidi-corp.com/shopify-power-bi-connector/

 

It comes with a free Power BI dashboard which I found super useful