Development discussions around Shopify APIs
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
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?
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
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.
@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?
@ 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?
is it difficult to creat an app? i have no programming skills.
Maybe we can chat in slack or TEAMS?
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.
We are happy to help you with this connection. Please email me me at firstname.lastname@example.org
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
maybe you can send me a PM to further clarify your request and to see if I could help you in this issue.
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.
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
Thanks to all Community members that participated in our inaugural 2 week AMA on the new E...By Jacqui Mar 10, 2023
Upskill and stand out with the new Shopify Foundations Certification programBy SarahF_Shopify Mar 6, 2023
One of the key components to running a successful online business is having clear and co...By Ollie Mar 6, 2023