how to connect shopify to power bi?

Matthias_Schniz
New Member
4 0 0

HI i am looking for a solution to connect my Shopify data to power bi.
Can anyone help me with that?  Didn't find anything helpful so far

Would be great. Thank you

0 Likes
CourtneyMiller
Excursionist
30 1 1

Hi @Matthias_Schniz , have you tried simply exporting your Shopify data as a CSV and importing it into PowerBI? What specifically are you hoping to use PowerBI to accomplish?

0 Likes
Matthias_Schniz
New Member
4 0 0

Thanks for the response.
No i  havent tried it yet. I wanted to use an API solution sothat i can automate the process.


My goal is i want to analyze all my orders and turnover from Shopify sales in PBI

0 Likes

Hi @Matthias_Schniz ,

if  I recall it correctly Power BI has added Python some time ago. Then you can use just a private app together with Python to do requests to the APIs. I am using this to do reporting with a Jupyter Notebook and it works like a charm. That should transfer to Power BI.

Regards
Thomas

• War meine Antwort hilfreich? Hinterlasse bitte ein Like.
• Hat meine Antwort Dein Problem gelöst? Bitte akzeptiere sie als Lösung.
0 Likes
CourtneyMiller
Excursionist
30 1 1

@Matthias_Schniz gotcha. How frequently do you want Shopify data to be exported to PowerBI? And you want it to be done on it's only schedule, rather than having to manually trigger it right?

0 Likes
Matthias_Schniz
New Member
4 0 0

@ Courtney Miller 

exactly. Actually every two weeks is fine or even 1  a month.

I prefer it scheduled when it's easy to set up. Do you know a way?

0 Likes
Matthias_Schniz
New Member
4 0 0

Hi Thomas

is it difficult to creat an app? i have no programming skills.
Maybe we can chat in slack or TEAMS?

0 Likes
CourtneyMiller
Excursionist
30 1 1

If you can use javascript, check out https://shypyard.io. We created this integration platform to allow merchants and developers to quickly link together their backend systems. It's free to use, forever if you're only syncing data twice per month. Sign up here: https://dashboard.shypyard.io/auth/signUp 

0 Likes

Hi @Matthias_Schniz,

to create a private app is matter or minutes, see https://help.shopify.com/en/manual/apps/private-apps

I can send you a Python example in a private message to get you started.

 

Regards
Thomas

• War meine Antwort hilfreich? Hinterlasse bitte ein Like.
• Hat meine Antwort Dein Problem gelöst? Bitte akzeptiere sie als Lösung.
0 Likes
Anto_S
Tourist
20 0 3

Hi @Matthias_Schniz 

We are happy to help you with this connection. Please email me me at anto@opstack.co

Thanks

Anto

 

 

 

0 Likes