Power BI Connector

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

Free plan available


4.6 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 of 5 stars
    0% of ratings are 4 stars
  • 3 of 5 stars
    10% of ratings are 3 stars
  • 2 of 5 stars
    10% of ratings are 2 stars
  • 1 of 5 stars
    0% of ratings are 1 stars
10 reviews

Africa's Queen

Great app and great customer service, the tool is very helpful in generating the report that I wanted.

Lully Bye Baby

The support has been fantastic and they've customised a report for us quickly and easily. Really happy with this app and highly recommend it!

Wear It Feel It

Great service and great product! The customer service is very fast in responding to help resolving my issues.

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


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

Jasper Industrial Supply

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.

Developer reply

March 30, 2021

Hello Jasper Industrial Supply,

Thank you for your positive review!

Kind regards,
Alpha Serve Support Team

Kitchen Center

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

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.


We use this app to import data to Power BI Desktop, it gets the job done. We would appreciate having the possibility to refresh Data Sources more than 1 time a day. Support is very responsive and helped us to resolve issues. Good work!


Introducing any tools in operation which are available in the market place always forces us to think whether it will solve our purpose or not. If we are fortunate enough to get the tools which is plug-n-play and solve our purpose then we feel happy. But most of the time it does not happen in that way. Because like our business our requirements are also unique. And in those situations which is obvious, it's all depends on the team behind the tool. How they listen to you? How they bring changes in the tools based on your requirement. This connector is blended with perfect team and perfect solution for any business. I am happy to be a user of this connector and it works perfect in operation.

Developer reply

June 16, 2020

Hi SquareDubai,

Thank you for your feedback!

Kind regards,

Alpha Serve Support Team