how to connect shopify to power bi?

[Matthias_Schniz]

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

[CourtneyMiller]

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]

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]

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

[Matthias_Schniz]

Hi Thomas

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

[tewe]

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

[CourtneyMiller]

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

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

[CourtneyMiller]

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 

[Anto_S]

Hi @Matthias_Schniz 

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

Thanks

Anto

[antser]

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]

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

[AnnaO]

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

[AdelH32]

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