Orders and shipping | Inventory management | Reporting
Power BI Connector

Power BI Connector

by Alpha Serve

Export store data to Power BI to explore and visualize it.

4.4 of 5 stars(5 reviews)
Free plan available
Add app

Easy Data Export

Create multiple data sources to export the data you need. Merge your store data with other data sources to widen your data landscape.

Convenient Functionality

Explore the key data - customers, orders, inventory. Use filters to select the needed data. Schedule automated refresh and get data on time.

Informative Dashboards

Create reports, data dashboards and visualizations in Power BI with your store data. Analyze it & improve your efficiency and profitability.

About Power BI Connector

Power BI Connector is an application for Power BI Shopify integration. It allows you to easily export the key e-commerce data from your Shopify store to Microsoft Power BI for further visualization and analytics.

With this application you can:

  • stream key Shopify store data to Power BI and transfer raw data into an understandable format;
  • schedule automated refresh to get your data updated to a certain time and date;
  • merge your store data with other key data sources;
  • build convenient dashboards to keep a hand on your inventory, orders, customers and prices;
  • feel safe about your store data (our app does not collect any customer data).

Power BI Connector will be useful for Shopify store owners and managers who want to extract and analyze their e-commerce store data to be up to date, make corrections in assortment, pricing, customer offers etc.

It’s crucial that Power BI Connector is developed for users not having any special skills, as it does not require any additional competence to start using it. The app allows creating URL connections easily, without any specific knowledge.

Power BI Connector allows acquiring the actual and detailed information for informed strategic decisions. Now you can measure the KPIs and increase your margin and profit with transparent reporting.

Integrates with

  • Power BI

Media gallery

Support

Pricing

BASIC

Free

  • 1 Data Source

  • 5000 rows per table

  • Manual updates

  • Automated Weekly updates

PROFESSIONAL

$89/month

  • 5 Data Sources

  • Unlimited rows

  • Manual updates

  • Automated Weekly/Daily updates

  • Automated Continuous updates

  • Data filtering

UNLIMITED

$249/month

  • Unlimited Data Sources

  • Unlimited rows

  • Manual updates

  • Automated Weekly/Daily updates

  • Automated Continuous updates

  • Data filtering

* All charges are billed in USD. Recurring charges, including monthly or usage-based charges, are billed every 30 days.

4.4 of 5 stars

The overall rating reflects the current state of the app. It accounts for all app reviews but prioritizes the most recent ones.
  • 5 of 5 stars
    80% of ratings are 5 stars
    (4)
  • 4 of 5 stars
    0% of ratings are 4 stars
    (0)
  • 3 of 5 stars
    0% of ratings are 3 stars
    (0)
  • 2 of 5 stars
    20% of ratings are 2 stars
    (1)
  • 1 of 5 stars
    0% of ratings are 1 stars
    (0)
View all 5 reviews

Most recent reviews

Jasper Industrial Supply

Rating
5 of 5 stars
Last edited
December 11, 2020

So far this app has been really good for us. Our financial controller was doing all kinds of reconciliations with Shopify manually, and I was able to replicate her large spreadsheet with the click of a button. The only drawback I have noticed is the inability to get actual shipping charges. The customer may get free shipping, but we still have to pay for a shipping label. I have no way to account for my label costs to get true profitability. Other tools we have used have access to this field so I hope the PBI Connector can eventually get it.

Kitchen Center

Rating
2 of 5 stars
Posted
August 26, 2020

Hi, auto update is not working in continuous. I need a constant update. how does auto update continuous work?

Developer reply

August 27, 2020

Hello Sebastian,

Thank you for reaching out to us.

As you may know, according to our request Shopify has granted us permission to allow our users to export orders for the whole period. Since then the data preparation time on Shopify's side has greatly increased. As a consequence, the number of timeout errors in Power BI increased, too. Data preparation fully depends on Shopify, we do not control the process and the data preparation time always varies. E.g. according to the log files, data preparation time varies from seconds to hours, and for some cases, it reaches 7 hours. To avoid Power BI timeouts errors the process was split into two parts: data preparation in Shopify and data refresh in Power BI.

When you set up continuous data preparation for your source, data preparation automatically starts after the previous has finished. You are able to get fresh data multiple times during the day by refreshing your data set in Power BI while the data preparation process runs in the background in Shopify. Data preparation time depends on the amount of data chosen for export. You can check the last time data has been prepared in the 'Prepared at' column.

Please note that due to Shopify API limitations, data preparation can be done one at a time. In case you create more than one source with continuous data preparation, data preparation will automatically start for the first source after the data preparation for the second source has been finished.

Hope this explains how continuous update works.

Please let me know if you have further questions or concerns. Your feedback is valuable to us.

Kind regards,
Alpha Serve Support Team

First Emergency

Rating
5 of 5 stars
Posted
August 14, 2020

I found it incredibly easy to figure out how to connect my store with Power BI. This is a great app and extensively used by our teams for creating reports. Fantastic app and a huge time saver for us.

View all reviews