cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jbotero Frequent Visitor
Frequent Visitor

Power BI integration with ecommerce cloud platform

Hello everyone.

 

At the company, we have been using a cloud-based e-commerce platform called VTEX (similar to Shopify). Currently, we are exporting .csv files in a montly basis, but we need to connect live (or "refreshable") to the database. VTEX provides a developers resource library, we refer to the API collection for the orders module, but we have been unable to connect to it following those instructions.

 

We are working in Power BI Desktop (2.56.5023.942 64-bit) and trying to connect to external data via web option, but with no luck at the inputs of the URLs, tokens and keys. 

 

We want to know if is possible to connect in that way or with any other means Power BI may offer to request and get the order information? Is the web approach the way or do we have to get data using a different source?

 

Thanks for your help and hope I have been clear in my question.

 

Juan

2 REPLIES 2
Highlighted
Moderator v-yuezhe-msft
Moderator

Re: Power BI integration with ecommerce cloud platform

@jbotero,

What error message do you get when you use Web entry in Power BI Desktop? You can enter the API’s address and required header information in Web.Contents() function to connect to your data source, there is a similar blog for your reference.

https://jessedotnet.com/2016/06/24/power-bi-connect-to-your-secure-api/

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
jbotero Frequent Visitor
Frequent Visitor

Re: Power BI integration with ecommerce cloud platform

Hello Lydia.

 

Thanks for your reply. I found the blog post very useful, but sadly, Power BI keeps getting an error with the request. Please find attached the image with the exact error (black part is the API key).error1.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

We have also tried to connect anonymously directly without Query Editor with no luck, as Power BI says the credentials are not correct.

 

Thank you in advance for your kind cooperation.

 

Best regards,

Juan

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors