FROM CACHE - en_header

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

Replies 13 (13)
CourtneyMiller
Excursionist
79 1 3

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?

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

tewe
Shopify Partner
237 44 102

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

• Was my reply helpful? Click Like to let me know!
• Was your question answered? Mark it as an Accepted Solution
• Check out our Price Updater App
CourtneyMiller
Excursionist
79 1 3

@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?

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?

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?

CourtneyMiller
Excursionist
79 1 3

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 

tewe
Shopify Partner
237 44 102

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

• Was my reply helpful? Click Like to let me know!
• Was your question answered? Mark it as an Accepted Solution
• Check out our Price Updater App
Anto_S
Shopify Partner
146 4 18

Hi @Matthias_Schniz 

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

Thanks

Anto

 

 

 

Automating Commerce at Comstack.co
Email: anto@comstack.co
antser
New Member
1 0 0

Hi Anto

I am facing a similar issue. I wish to download in a daily basis data from Shopify to Power BI. I will create a model in Power BI because I will also download data from another source. So, I will report both data sources (Shopify and external) as ONE model.

I am confused of what should I do to establish the Shopify to Power BI connection. I would really appreciate if you could give me some guideline.

 

Thanks in advance

Antonis

tewe
Shopify Partner
237 44 102

Hi Antonis,

 

maybe you can send me a PM to further clarify your request and to see if I could help you in this issue.

 

Regards
Thomas

• Was my reply helpful? Click Like to let me know!
• Was your question answered? Mark it as an Accepted Solution
• Check out our Price Updater App
AdelH32
Tourist
5 0 1

Hi, you can use one of the available apps in shopify app store, that will connect shopify data to  power bi.
This one has helped us get what we need.
https://apps.shopify.com/windsor-connector

AnnaO
Shopify Partner
11 0 1

Dear Antonis,

You can try our app for this - Power BI Connector: https://apps.shopify.com/power-bi-connector-1? 

It can solve your task. Feel free to ask me if you need any support in this.

Anna | Alpha Serve

Alpha Serve | Shopify Apps