Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Shopify API

I am trying to bring shopify  orders into Power BI desktop but seems I can not import more than 250 orders, this query brings 250 orders and fails at 251. anyone has any idea? Thank you.   let   ...
Need Help
EugeneLebedev's avatar
EugeneLebedev
Icon for Helper V rankHelper V
2 years ago

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: https://vidi-corp.com/shopify-power-bi-connector/