Forum Discussion

Jameswh91's avatar
Jameswh91
Helper III
3 years ago

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 appreci...
Need Help
Show and Tell
Tips and Tricks
ReportGuru's avatar
ReportGuru
Post Patron
2 years ago

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:

 

 

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.