hello,
I try to set up the import of my shopify data in Power BI. I created an app as a API. Then, in PBI i use the web gateway with this url :
https:// [shop name} .my shopify.com/admin/api/2024-04/orders.json?limit=250
It works well but as soon I want more than 250 rows to get all the data, it fails :
DataSource.Error: Web.Contents failed to get contents from ’ https: //{shopname}.myshopify.com/admin/api/2024-04/orders.json?limit=251 ’ (400): Bad Request
Details:
DataSourceKind=Web
DataSourcePath= https: //{shopname}.myshopify.com/admin/api/2024-04/orders.json
Url=https //{shopname}.myshopify.com/admin/api/2024-04/orders.json?limit=251
I wasn’t expecting it is quite difficult to set up the import from shopify to PBI, maybe the method is wrong ? or if I am on the right way, do you have the solution to get the tabs for the orders, customers,…
Thanks in advance
Actually, you can’t import all orders to PowerBI at once. The limit per request is 250 items. After the first request, the response includes a pagination link to the next page. For example, to export 1000 orders, you need to send 4 requests.
To resolve this situation, you need an app between Shopify and PowerBI. This app shoud import all orders into its own database in real-time using webhooks.
Then, you can make requests to the app without limitations.
You can check out our app, Mipler Flow https://apps.shopify.com/mipler-flow , which provides an API interface to export flow results (orders) without pagination.
Why use PowerBI - there are a lot of reporting apps that can give you data cheaper and better.
Because poeple in my organisation has a lot of excel reports interpreting the data and they do repetitive operation after downloading every week the csv export. So I wanted to automatize the export and the automation with Power Query.
If you have an other solution in mind, I would love to know it.
1 Like
Thank you for your answer. It is very helpfull, I will try your solution.
Sure, our Report Toaster app can help. You can create custom reports and download the results to CSV or have them automatically emailed on a schedule. Feel free to reach out to support for help with customization or scheduling.
More importantly, you can customize the reports to the point that your staff will most likely not need to do any manipulation, or at least not as much. Will pay for itself over and over…