Alpha Serve Power BI Connector

Alpha Serve Power BI Connector

From $29/month. Free trial available.
Rating (4.7)
Reviews
Developer

Highlights

Built for your business
  • Use directly in Shopify admin

About this app

Launched

February 26, 2020

Languages

English

Works with

Power BI

No-code Power BI integration. Export store data to Power BI to build any reports you need easily.

Power BI Connector for Shopify is a Power BI Shopify integration app enabling easy Shopify data export to Microsoft Power BI for further visualization and data analysis. Connect Shopify to Power BI and build interactive Shopify reports to analyze inventory, customers, orders etc. Power BI Connector is a no-code and ready-to-use integration. It will be useful for Shopify store owners/managers willing to measure the KPIs and increase margin and Shopify profit with transparent Shopify reporting.

Power BI Connector for Shopify is a Power BI Shopify integration app enabling easy Shopify data export to Microsoft Power BI for further visualization and data analysis. Connect Shopify to Power BI and build interactive Shopify reports to analyze inventory, customers, orders etc. Power BI Connector is a no-code and ready-to-use integration. It will be useful for Shopify store owners/managers willing to measure the KPIs and increase margin and Shopify profit with transparent Shopify reporting. more
  • Export Shopify data to Power BI and transfer raw data into interactive report
  • Schedule automated refresh for real-time Shopify Power BI reports
  • Merge Shopify data with other data sources (CRM, ERP etc) for complex reporting
  • Keep your store data safe (our app does not collect any customer data)
  • Apply filters to select data you need. Export any Shopify data in unlimited rows

Pricing

BASIC

$29 / month

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

14-day free trial

PROFESSIONAL

$89 / month

  • 5 Data Sources
  • Unlimited rows
  • Manual updates
  • Automated Weekly/Daily updates
  • Automated Continuous updates
  • Data filtering

14-day free trial

UNLIMITED

$249 / month

  • Unlimited Data Sources
  • Unlimited rows
  • Manual updates
  • Automated Weekly/Daily updates
  • Automated Continuous updates
  • Data filtering

14-day free trial

BASIC

$29 / month

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

14-day free trial

PROFESSIONAL

$89 / month

  • 5 Data Sources
  • Unlimited rows
  • Manual updates
  • Automated Weekly/Daily updates
  • Automated Continuous updates
  • Data filtering

14-day free trial

UNLIMITED

$249 / month

  • Unlimited Data Sources
  • Unlimited rows
  • Manual updates
  • Automated Weekly/Daily updates
  • Automated Continuous updates
  • Data filtering

14-day free trial

All charges are billed in USD. Recurring and usage-based charges are billed every 30 days. See all pricing options

7 reviews

Overall rating
4.7
Counts per rating level
  • 71% of ratings are 5 stars
  • 0% of ratings are 4 stars
  • 14% of ratings are 3 stars
  • 14% of ratings are 2 stars
  • 0% of ratings are 1 stars
July 3, 2023

When Shopify switch to cursor based pagination we needed an easy way to connect our Power BI reports to Shopify and this app helped us do that. Easy to use and the data layer user interface makes sense. Developer keeps it up to date with Shopify API changes. Be aware that this app has a scheduler for refreshing the data sources so just because you refresh the Power BI report doesn't mean the data source refreshed, but I can't fault the developer for that.

Mojo Spa
United States
Over 1 year using the app
March 4, 2021

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.

Schwinn Bikes
United States
Almost 2 years using the app
Alpha Serve replied March 30, 2021

Hello Schwinn Bikes,

Thank you for your positive review!

Kind regards,
Alpha Serve Support Team

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.

Jasper Industrial Supply
United States
7 months using the app
Alpha Serve replied March 30, 2021

Hello Jasper Industrial Supply,

Thank you for your positive review!

Kind regards,
Alpha Serve Support Team

May 24, 2022

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.

MANITOBA Sandbox
Canada
21 days using the app
Alpha Serve replied 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

March 29, 2021

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?

Hei Hei
Chile
3 months using the app
Alpha Serve replied 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

About this app

Launched

February 26, 2020

Languages

English

Works with

Power BI

Built by Alpha Serve

About Alpha Serve

4.9 average rating

4 years building apps for the Shopify App Store

153 E Flagler St #266, Miami, FL, 33131, US

Support

Send a message

+38 098 03 77 286

support@alpha-serve.com

More apps like this

4.8 out of 5 stars 13 total reviews Free plan available
Automated XML feed for Skroutz to increase sales & visibility
3.4 out of 5 stars 385 total reviews Free
Sell your products on any website or blog.
5.0 out of 5 stars 5 total reviews Free to install
Professional free ERP software helps you become a big seller

Want to add an app?

Try Shopify free for 3 days