Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper III
Helper III

Shopify Data Modelling



Has anyone built a data model using to shopify tables. Should i merge the tables or use relationships for them. I've not used a data model like this prior so any help would be much appreciated. 

Helper V
Helper V

Hi @Jameswh91 I know this reply is very late lol but were you able to find a solution? Since there’s no direct connection to Shopify anymore, you will have to look for another way. As a workaround, maybe you can try to test your connection with a 3rd party connector. I've tried, supemetrics (which doesn't have PBI as a destination, so you first have to export to Google Sheets and then export to PBI) and I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the Shopify connector in the data sources list:




After that, just grant access to your Bing Ads account using your credentials, then on preview and destination page you will see a preview of your Shopify fields:




There just select the fields you need. Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url.



New Member

It's great to see discussions on utilizing Power BI for analyzing and visualizing Shopify data. If you're interested in diving deeper into the pros and cons of using Shopify as an e-commerce platform, I recommend checking out the article Exploring the pros and cons will give you a comprehensive understanding of the platform's capabilities and potential limitations. In past its really help me in my business

New Member

I found this post on Shopify data modeling in Power BI quite informative. As a Power BI user, it's crucial to effectively model and transform your data to extract meaningful insights. Understanding the underlying structure and relationships of your Shopify data is essential for creating accurate and insightful visualizations. I appreciate the tips and discussions shared in this post, particularly the focus on defining relationships, managing data granularity, and optimizing performance

Regular Visitor

Thank you for sharing your experience and insights on Shopify data modeling in Power BI. Data modeling is a crucial step in creating meaningful visualizations and gaining valuable insights from your Shopify data. It's great to see the community discussing various approaches and best practices for data modeling in Power BI with Shopify

Helper III
Helper III

Hi @Jameswh91 

You can use Power BI Connector with a data model where the relations are built automatically. 





Helper III
Helper III

i'm not sure why you would need a data model for this, or merging table, if there is free shopify to Power bi connector.
try this app
this is the how to
and a free template to get you started

Community Support
Community Support

Helpful resources


Fabric certifications survey

Certification feedback opportunity for the community.


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.