Hi Shopify team!
I wish to download the Shopify data into Power BI and create a model for sophisticated reporting.
Does anyone know which are the connectors approved by Shopify?
Thanks in advance
Topic summary
A user seeks recommendations for Shopify-approved Power BI connectors to enable sophisticated reporting. Several solutions are suggested:
Recommended Connectors:
- Windsor Connector (available on Shopify App Store)
- Power BI Connector by Alpha Serve
- Vidi Corp connector for Azure integration
- Skyvia for data sync to databases/data lakes
Technical Challenge Identified:
One participant reports sales figures not matching between Shopify and Power BI, attributing this to Shopify’s unique measurement methods.
Proposed Solution:
A detailed formula is shared for calculating net sales in Power BI, requiring:
- Line item quantity and price
- Discount allocations (extracted from JSON fields)
- Order-level refund data and tax amounts
Key complexity: Refunds appear at order level rather than line-item level, requiring proportional allocation across products. The formula approximates accuracy but isn’t perfect due to partial returns and refund allocation challenges.
The discussion remains open with multiple viable connector options presented, though sales reconciliation requires careful measure construction.
2 Likes
Hi there is many approved, i’ve been using this one https://apps.shopify.com/windsor-connector to connect shopify data to Power bi for a while now, and it’s exactly what we need.
Hi Paolita,
You can take a look at our app on the Shopify App Store - Power BI Connector: https://apps.shopify.com/power-bi-connector-1?
It does exactly what you’re asking for. May be it can help you solve your reporting task.
Anna | Alpha Serve
Hi @Paolita , I brought my shopify data into Azure so that I can pull it into Power BI. I’m now creating reports, but for some reason, my sales are not matching Shopify. I think Shopify measures sales in weird ways. Have you been successful in creating a sales measure in Power BI that you’re confident in?
I also extracted data from Shopify into Azure using a Vidi Corp connector. The measure for net sales is below (it is matching closely but not 100% because of the refunds)
following fields are needed in order to calculate net sales:
[line_item__quantity] – quantity including returns
[line_item__price] - product price before discount and returns.
[line_item__discount_allocations] - JSON field from which you can get a discount for a certain product: [line_item__discount_allocations].[0].[allocatedAmountSet].[shopMoney].[amount] check screenshot below:
[order_refunds_net] – the total refund amount including tax
[order_refunds_total_tax] –total tax amount for the refund.
To calculate NetSales you need to multiply quantity * product price for every row of data and then subtract discount amount and refunds
There are complexities here because refunds are shown on order level rather than order line level which means you can’t allocate them to products. Sometimes you have partial returns. The only way of allocating refunds to product is to divide them between the products in this order.
This is not the cleanest way but it is approximately right
Вот формула:
You can pull data via Shopify’s API combined with Power BI’s web connector. Others work through apps that export your orders and customers into a database or cloud storage, which Power BI can read. I’ve seen Skyvia used in setups like this, quietly handling data sync to databases or data lakes that Power BI taps into. It adds flexibility and keeps things smooth as your reporting needs grow.