Power BI reads Microsoft Excel and BigQuery as native connectors. SyncRange keeps Shopify data fresh in Excel or BigQuery so you can build Power BI reports that update automatically, without brittle manual exports.
Connect, choose columns, schedule refreshes
Power BI reports read from connectors such as Microsoft Excel and BigQuery. SyncRange focuses on keeping Shopify accurate inside those destinations. Think of us as the sync layer, not a charting substitute.
After data lands on a schedule, you build Power BI visuals and data models the same way you would for any other business data. Power BI stays fast because the heavy lifting happens in Excel or BigQuery.
Power BI connects natively to BigQuery and Microsoft Excel. SyncRange does not build visuals inside Power BI. We keep Shopify synchronized into those destinations so your reports and data models stay fast and auditable.
What we can export, and how it lands
Each row is a field you can include or omit in the app before export. Column headers match the labels below; SyncRange writes them as the first row in your destination (worksheets in Google Sheets or Excel, or BigQuery columns) when you choose Power BI.
Export product and variant information
| Columns |
|---|
| Product ID |
| Product Title |
| Variant ID |
| Variant Title |
| SKU |
| Barcode |
| Product Type |
| Vendor |
| Product Tags |
| Description |
| Price |
| Compare at Price |
| Weight |
| Weight Unit |
| Inventory Quantity |
| Inventory Policy |
| Requires Shipping |
| Taxable |
| Status |
| Published |
| Published Date |
| Created Date |
| Updated Date |
| Handle |
| Image URL |
| Collections |
| Options |
| Date Exported |
Export order and sales information
| Columns |
|---|
| Order ID |
| Order Number |
| Order Date |
| Order Date Time |
| Customer ID |
| Customer Name |
| Customer Email |
| Customer Phone |
| Customer Address Line 1 |
| Customer Address Line 2 |
| Customer City |
| Customer Province/State |
| Customer Country |
| Customer Country Code |
| Customer Zip/Postal Code |
| Fulfillment Status |
| Financial Status |
| Currency |
| Subtotal |
| Shipping |
| Taxes |
| Discounts |
| Total Price |
| Refunded Amount |
| Quantity Sold |
| Discount Codes Applied |
| Discount Code IDs |
| Manual Discount Codes |
| Automatic Discount Titles |
| Discount Codes Applied (JSON) |
| Discount Code IDs (JSON) |
| Order Source |
| Referring Site |
| Landing Site |
| Order Tags |
| Order Note |
| Order Note Attributes |
| Date Exported |
Export store information
| Columns |
|---|
| Store ID |
| Store Name |
| Store Email |
| Store Domain |
| Primary Domain |
| Plan Name |
| Shopify Plus |
| Currency |
| Country |
| City |
| Zip/Postal Code |
| Contact Email |
| Customer Accounts |
| Taxes Included |
| Tax Shipping |
| Has Gift Cards |
| Has International Domains |
| Date Exported |
Export inventory cost and value information
| Columns |
|---|
| Inventory Item ID |
| Variant ID |
| Product ID |
| Product Title |
| Variant Title |
| SKU |
| Quantity |
| Cost per Item |
| Currency |
| Total Value |
| Tracked |
| Country of Origin |
| Province of Origin |
| HS Code |
| Product Type |
| Vendor |
| Date Exported |
Export inventory data with location information
| Columns |
|---|
| Inventory Item ID |
| SKU |
| Tracked |
| Variant ID |
| Variant Title |
| Variant Price |
| Product ID |
| Product Title |
| Product Type |
| Vendor |
| Location ID |
| Location Name |
| Quantity |
| Date Exported |
Export detailed line item information from orders
| Columns |
|---|
| Line Item ID |
| Order ID |
| Order Number |
| Order Date |
| Order Date Time |
| Line Item Name |
| Line Item Type |
| Quantity |
| Unit Price |
| Currency |
| Total Price |
| Refunded Amount |
| Discount Amount |
| Discount Codes Applied |
| Discount Code IDs |
| Manual Discount Codes |
| Automatic Discount Titles |
| Discount Codes Applied (JSON) |
| Discount Code IDs (JSON) |
| Discounted Price |
| Tax Amount |
| Tax Rate |
| Tax Name |
| SKU |
| Variant ID |
| Variant Title |
| Product ID |
| Product Title |
| Product Type |
| Vendor |
| Fulfillment Date |
| Fulfillment Status |
| Is Gift Card |
| Refundable Quantity |
| Date Exported |
Export customer information
| Columns |
|---|
| Customer ID |
| First Name |
| Last Name |
| Notes |
| Account Created Datetime |
| Account Created Date |
| Account Age in Days |
| Last Order Created Datetime |
| Last Order Created Date |
| Address Line 1 |
| Address Line 2 |
| City |
| Province/State |
| Country |
| Country Code |
| Zip/Postal Code |
| Customer Segment IDs |
| Customer Segment Names |
| Customer Segment IDs (JSON) |
| Customer Segment Names (JSON) |
| Date Exported |
Export detailed sales metrics and financial data
| Columns |
|---|
| Order ID |
| Order Number |
| Order Date |
| Customer Name |
| Gross Sales |
| Discounts |
| Returns |
| Net Sales |
| Shipping |
| Tax |
| Duties |
| Total Sales |
| Currency |
| Payment Method |
| Fulfillment Status |
| Financial Status |
| Date Exported |
Export store locations and fulfillment centers
| Columns |
|---|
| Location ID |
| Location Name |
| Address Line 1 |
| Address Line 2 |
| City |
| Province/State |
| Zip/Postal Code |
| Country |
| Country Code |
| Phone |
| Is Active |
| Fulfills Online Orders |
| Has Active Inventory |
| Ships Inventory |
| Date Exported |
Export collection information with optional metafield columns
| Columns |
|---|
| Collection ID |
| Title |
| Handle |
| Description |
| Sort Order |
| Products Count |
| Updated At |
| Date Exported |
Export one row per customer per segment membership. Covers every segment in the store.
| Columns |
|---|
| Segment ID |
| Segment Name |
| Customer ID |
| Customer Display Name |
| First Name |
| Last Name |
| Number of Orders |
| Amount Spent |
| Amount Spent Currency |
| Date Exported |
Export discount definitions. One row per discount code; automatic discounts produce one row.
| Columns |
|---|
| Discount ID |
| Discount Type |
| Discount Title |
| Discount Summary |
| Status |
| Discount Code |
| Total Used Count |
| Code Used Count |
| Limit Total Times |
| Limit One Use Per Customer |
| Starts At |
| Ends At |
| Created At |
| Updated At |
| Discount Value Type |
| Discount Value |
| Value Currency |
| Minimum Purchase Type |
| Minimum Value |
| Eligibility Type |
| Eligibility Values |
| Eligibility Customer Segment IDs |
| Eligibility Customer Segment Names |
| Eligibility Customer Segment IDs (JSON) |
| Eligibility Customer Segment Names (JSON) |
| Combines With Order Discounts |
| Combines With Product Discounts |
| Combines With Shipping Discounts |
| Discount URL |
| Date Exported |
Per-product or per-variant revenue over the selected date range: gross sales, discounts, returns, net sales, tax, units, and order counts (from line items and refunds, streamed for large stores). Optional breakdown by variant for SKU- or size-level metrics.
| Columns |
|---|
| Product ID |
| Variant ID |
| Variant Title |
| SKU |
| Product Title |
| Product Type |
| Vendor |
| Currency |
| Gross Sales |
| Discounts |
| Returns |
| Net Sales |
| Tax |
| Total Sales |
| Units Sold |
| Orders |
| Date Exported |
Per-product refund stats over the selected date range: refunded units, refund amount, refund counts, refund rates vs sales, average refund value, and average days from order to refund (streamed for large stores).
| Columns |
|---|
| Product ID |
| Product Title |
| Product Type |
| Vendor |
| Currency |
| Units Sold |
| Gross Sales |
| Orders With Product |
| Refunded Units |
| Refund Amount |
| Refund Line Items |
| Orders Refunded |
| Net Units |
| Net Sales |
| Refund Rate (Units) |
| Refund Rate ($) |
| Avg Refund Value |
| Avg Refund Quantity |
| Avg Days to Refund |
| Date Exported |
Export Shopify Payments bank transfer summaries with rolled-up charge, refund, and adjustment fees. Requires Shopify Payments and the read_shopify_payments_accounts and read_shopify_payments_payouts OAuth scopes.
| Columns |
|---|
| Payout ID |
| Payout Date |
| Status |
| Type |
| Net Amount |
| Currency |
| Charges Gross |
| Charges Fee |
| Refunds Gross |
| Refunds Fee |
| Adjustments Gross |
| Adjustments Fee |
| Date Exported |
Export every Shopify Payments charge, refund, and adjustment with gross, fee, net, order link, and payout link. Requires Shopify Payments and the read_shopify_payments_accounts and read_shopify_payments_payouts OAuth scopes.
| Columns |
|---|
| Balance Transaction ID |
| Transaction Date |
| Type |
| Source Type |
| Test |
| Order ID |
| Order Number |
| Payout ID |
| Payout Status |
| Gross Amount |
| Fee Amount |
| Net Amount |
| Currency |
| Source ID |
| Source Order Transaction ID |
| Adjustment Reason |
| Date Exported |
One row per refund line item over the selected date range with return reason, restock type, and customer note (streamed for large stores).
| Columns |
|---|
| Refund Line ID |
| Order ID |
| Order Name |
| Order Date |
| Order Date Time |
| Refund Date |
| Line Item Name |
| Refunded Quantity |
| Refund Price (per unit) |
| Refund Amount |
| SKU |
| Variant ID |
| Variant Title |
| Product ID |
| Product Title |
| Product Type |
| Vendor |
| Return Reason |
| Return Reason Note |
| Customer Note |
| Restock Type |
| Restocked |
| Discount Codes Applied |
| Manual Discount Codes |
| Automatic Discount Titles |
| Discount Codes Applied (JSON) |
| Is Gift Card |
| Date Exported |
Social proof
See how teams export clean ecommerce and marketing data to Google Sheets, Microsoft Excel, or BigQuery without manual work.
Shopify Store and Food delivery
Super easy to use and has been extremely useful in getting the real time data we need from our Shopify store. Ryan was super helpful in getting started, and responded to questions within minutes. Highly recommend.
Multi-brand Shopify Plus Operator
We run multiple Shopify stores and needed brand-level exports into BigQuery without custom pipeline maintenance. SyncRange gave us reliable scheduled exports and removed hours of manual QA.
Shopify Store Founder
We were manually updating Google Sheets every morning with Shopify and ad data. It was slow and error-prone. Now everything updates automatically, and our daily profitability tracker is always accurate.
Large Shopify Store
SyncRange was very helpful setting up Report Automation for my store. Highly recommend, Ryan made it as simple as possible and was very easy to work with. I recommend.
Connect your account, then follow the configuration guide for your first export.
Other data sources you can sync to Power BI
