Skip to main content
cancel
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.

Reply
Jameswh91
Helper III
Helper III

Shopify Data Modelling

Hi, 

 

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. 

7 REPLIES 7
ReportGuru
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 windsor.ai, supemetrics (which doesn't have PBI as a destination, so you first have to export to Google Sheets and then export to PBI) and funnel.io. 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:

 

SHOPIFY-1.jpg

 

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:

 

SHOPIFY-2.jpg

 

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.

 

SELECT_DESTINATION_NEW.png

faronim
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 https://claspo.io/blog/16-shopify-pros-and-cons-reviewed/. 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

josbrodin
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

bandini
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

ltopchyi
Helper III
Helper III

Hi @Jameswh91 

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

Liubov

 

 

 

Adel
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 https://apps.shopify.com/windsor-connector
this is the how to https://windsor.ai/connect-shopify-to-power-bi/
and a free template to get you started https://appsource.microsoft.com/en-us/product/power-bi/windsorgroupgmbh1585043281642.shopify-store-o...

v-luwang-msft
Community Support
Community Support

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

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.