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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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.

3 REPLIES 3
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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors