Unable connect Shopify to Power BI

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