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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Jameswh91
Helper III
Helper III

Unable to connect to shopify api

Hi, so i'm trying to connect our shopify stores to power bi but as i try to connect via the basic web authentication i get the error "The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel."

 

Has anyone connected directly to shopify previously? Or would people reccommend an alternative solution in which to bring shopify and amazon data to power bi?

 

Many thanks for any advice received.

5 REPLIES 5
QueryWhiz
Post Patron
Post Patron

Hi @Jameswh91 were you able to find a solution? As a workaround, maybe you can try to test your connection with a 3rd party connector. I've tried windsor.ai, supemetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the Shopify connector in the data sources list:

 

SHOPIFY-1.jpg

 

After that, you need to follow instructions and install the windsor.ai app from the Shopify App Store:

 

SHOPIFY-1.5.png

 

then on preview and destination page you will see a preview of your Shopify fields

 

SHOPIFY-2.jpg

 

There just select the fields you need. Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url

 

SELECT_DESTINATION_NEW.png

Aryna
Helper V
Helper V

Hi @Jameswh91 , yes, I developed Power Bi report from Shopify before. You can try this Power BI connector that I found helpful: https://vidi-corp.com/shopify-power-bi-connector/

They also offer free Power Bi teplates

ltopchyi
Helper III
Helper III

Hi @Jameswh91 

If you don't overcome the issue, you can consider a third-party add-on as an alternative: https://apps.shopify.com/power-bi-connector-1 It is paid but offers a free plan, though. 

Best regards,

Liuba

Adel
Helper III
Helper III

You could  use a tool called windsor.ai which has both connector shopify & amazon seller central to power bi.
Here is the how tos: 
https://windsor.ai/connect-shopify-to-power-bi/
https://windsor.ai/connect-amazon-mws-to-power-bi/

PhilipTreacy
Super User
Super User

Hi @Jameswh91 

 

I see that error when the domain being connected to does not match the name on the site's SSL certificate.

 

What is the API url you are using?  Can you confirm the domain name on the SSL certificate for that url?

 

Regards

 

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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