Forum Discussion
API web link to shopify only 50 rows returned in query editor
tomringer,
Based on my research, there is a limitation that each call returns only 50 records in Shopfiy Rest API, you may need to increase the limit in Shopfiy URL and loop the api call to return all records. There are similar threads for your reference.
https://ecommerce.shopify.com/c/shopify-apis-and-technology/t/single-call-to-order-api-only-returns-49-orders-393401
https://ecommerce.shopify.com/c/shopify-apis-and-technology/t/api-response-max-limit-444117
Regards,
Lydia
Hi tomringer , you can alternatively try a ready-mady Shopify Power BI connectors.
This provider offers a free Shopify Power BI template that already includes the main Shopify tables and built-in relationships, allowing you to connect your data and get going quickly: https://vidi-corp.com/shopify-analytics-dashboards/