Forum Discussion
How to create a query that paginates for Shopify API?
I am able to get data from Shopify API using basic authentication. Link: https://shopname.myshopify.com/admin/api/2019-10/products.json However, it doesn't return all the data. After some researc...
Shopify API is too difficult to create a custom Power BI connector in my opinion. I would recommend instead to extract data into an Azure SQL Server database. This way you work around most of the Shopify API limitations. Here is a ready-made solution for that which includes the product table that you were referring to: https://vidi-corp.com/shopify-power-bi-connector/