Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
newbie74
Frequent Visitor

Unable connect Shopify to Power BI

Dear community,

 

i don't manage to connect Power BI to my Shopify site data.

In shopify, i have created a private app that generated an API key, A password and a URL containing both (note that this address is following this format of secure url "https://{apikey}:{password}@{hostname}/admin/api/2021-10/orders.json" therefore not sure if it would lead to all tables/data i have selected during the setup of the Shopify private app)

In Power BI, i do GET DATA / WEB / Basic Url and i paste the URL.

Power bi shows the Access Web Content window but tells me "we could not authenticate with the credentials provided..."  in anonymous mode.

in the basic mode, i tried entering my shopify admin credentials, it doesn't work either.

 

Anybody with some help would be highly appreciated.

 

Many thanks in advance

 

1 ACCEPTED SOLUTION
newbie74
Frequent Visitor

I have found the answer and thought i would share the exact steps.

The Shopify API is a REST API.

 

To get data within power BI, here are the steps in Power BI:

1) Get DATA

2) select WEB

3) Enter the URL (as basic) from the private app in shopify ("https://{apikey}:{password}@{hostname}/admin/api/2021-10/orders.json")

4) Select BASIC authentification

5) Username is the API Key

6) Password is the API Password

 

And that's it, you will then get access to the data in JSON format, convert it to table, expand the records and clean the table.

 

Many thanks

View solution in original post

8 REPLIES 8
ltopchyi
Helper III
Helper III

Hi @newbie74,

You can take a look at the altenative option (just in case): https://apps.shopify.com/power-bi-connector-1 

Liubov

Harry33
Helper I
Helper I

I can recommend a third-party tool to connect Shopify and Power Bi — Skyvia. This no-coding solution provides integration through a database or cloud data warehouse with automatic schema creation. Then you can connect Power BI to this database or data warehouse easily.

adelheni
Helper III
Helper III

The best option I found and used is getting one of the apps that partners with Shopify.
https://apps.shopify.com/windsor-connector; this one has been working seemingly, we use to connect Shopify to power bi and Shopify to BigQuerry.

newbie74
Frequent Visitor

I have found the answer and thought i would share the exact steps.

The Shopify API is a REST API.

 

To get data within power BI, here are the steps in Power BI:

1) Get DATA

2) select WEB

3) Enter the URL (as basic) from the private app in shopify ("https://{apikey}:{password}@{hostname}/admin/api/2021-10/orders.json")

4) Select BASIC authentification

5) Username is the API Key

6) Password is the API Password

 

And that's it, you will then get access to the data in JSON format, convert it to table, expand the records and clean the table.

 

Many thanks

what is API Password??

Hi There,

 

Could you please help me to create the Private API?

vanessafvg
Super User
Super User

it looks like this gives a different way to connect?

 

i have no experience of it but maybe it can help?

 

https://www.alphaservesp.com/blog/power-bi-shopify-integration/





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Hi everyone,
I want to connect shopify with power bi but i can't find any option. i know there're some apps but i want to it manually.
Thanks

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.