Power BI Connector

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

Free plan available

App highlights

  • Seamless workflow: use directly in Shopify admin

  • Speed tested: no impact to your online store

Key values section

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.

Power BI Connector

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.

Launch date

Integrates with

  • Power BI
Power BI Connector

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.

Launch date

Integrates with

  • Power BI

FREE

Free

  • 1 Data Source
  • 500 rows per table
  • Manual updates
  • Automated Weekly updates

BASIC

$29/month

  • 2 Data Sources
  • 5000 rows per table
  • Manual updates
  • Automated Weekly/Daily updates
  • Data filtering

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.

Reviews

4.5 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
    67% of ratings are 5 stars
  • 4 of 5 stars
    0% of ratings are 4 stars
    0
  • 3 of 5 stars
    17% of ratings are 3 stars
  • 2 of 5 stars
    17% of ratings are 2 stars
  • 1 of 5 stars
    0% of ratings are 1 stars
    0

MANITOBA Sandbox

Location Canada

App works great. Be nice if there was additional documentation to help determine what fields i should pull in for orders though. Pulling in all of them can cause performance issues for large datasets. Once I narrowed it down everything worked well.

Developer reply

May 24, 2022

Hello Manitoba Team,

Thank you so much for taking the time to review our app. We're happy to see that you had a great experience with our application.

Please feel free to refer to our app documentation: https://aserve.atlassian.net/wiki/spaces/PBSHOPIFY/

Also, I'd like to share Entity-Relationship Diagram for the tables with you: https://powerbi-sh-prod.alphaservesp.com/overview#erd

Please let us know if you need any help.

Thank you.

Kind regards,
Alpha Serve Support Team

Hei Hei

I create a data source in my shipify to work with power bi, but when i try to import the Odata source with the shopif´s data source link, there is a message that says "El acceso al recurso se prohíbe"... what i have to do to get access to the resource?

Developer reply

March 30, 2021

Hello,

Thank you for reaching out to us.

Please let us answer your concerns:

Due to security reasons, in order to import the Data Source successfully, you should use the credentials provided at the Settings tab of the plugin. To solve the problem please do the following:
1. Clear the Data Source settings by following the steps provided in our documentation: https://aserve.atlassian.net/wiki/spaces/PBSHOPIFY/pages/1711996929/Access+to+the+resource+is+forbidden+error+troubleshooting
2. Use the credentials provided at the Settings tab of the plugin. For your convenience please review the demo video of how the authorization process works: https://youtu.be/dipFVY18zRI?t=101

Please contact us at support@alpha-serve.com in case you need further assistance.

Thank you.

Kind regards,
Alpha Serve Support Team

Schwinn Bikes

Great support team. Everything you could possibly need in a connector. This has been a huge help in automating what used to be a manual process.

Developer reply

March 30, 2021

Hello Schwinn Bikes,

Thank you for your positive review!

Kind regards,
Alpha Serve Support Team

Apps similar to Power BI Connector

Dynamics 365 Business Central

Dynamics 365 Business Central

Get in control of your inventory, finances, and tax reporting

No ratingNo reviews
Free to install
Katana Manufacturing ERP

Katana Manufacturing ERP

Inventory management, stock sync and production control

4.9 of 5 stars(131reviews)
14-day free trial
Merchbees Inventory Value

Merchbees Inventory Value

Know your stock value, inventory cost & quantity in real-time

5.0 of 5 stars(40reviews)
Free plan available
Inventory Planner Forecasting

Inventory Planner Forecasting

Create purchase orders, save time purchasing, advanced reports

4.7 of 5 stars(105reviews)
14-day free trial