Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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
Hi @newbie74,
You can take a look at the altenative option (just in case): https://apps.shopify.com/power-bi-connector-1
Liubov
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.
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.
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?
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/
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
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |