Connect VTEX to Power BI: Dashboards in Minutes
Get started for free
No credit card required | 14 days | 10 million records | 30 pipelines
or sign up with your email
By signing up, you agree to Kondado’s Terms of service and Privacy policy
Visualize VTEX Data in Power BI
Connect your VTEX store to Power BI without writing code or managing complex infrastructure. Kondado offers a direct connection that replicates your ecommerce data into Power BI on a configurable schedule, so your reports always reflect current sales, inventory, and customer behavior. Simply select VTEX as your data source, choose which pipelines to activate, and start building dashboards in minutes. Whether you need hourly updates for operations or daily summaries for executives, you control exactly how often your data refreshes.
Kondado connects VTEX to Power BI through a direct connection requiring no intermediate databases or technical setup, offering 17 data pipelines including Orders, Stock, and Marketing Data with automated updates configurable from every 5 minutes to daily.
Our prices start from $19 USD/month, and you can try Kondado for free for 14 days with no credit card required
Combine your VTEX Orders and Marketing Data pipelines in Power BI to uncover which campaigns actually drive revenue, not just clicks. Track how promotions impact inventory by connecting the Stock and Coupons pipelines, ensuring you never advertise products that are running low. With 17 pipelines covering everything from shipping logistics to SKU pricing, you can build comprehensive reports that help marketing teams optimize spend, operations teams prevent stockouts, and finance managers track payment trends across multiple sales channels.
Try out all the features for free for 14 days
VTEX data available in Power BI
Available integrations
| Integration | Description |
|---|---|
| Coupons | Includes fields like coupon_id, expirationintervalperuse, and isarchived, allowing management of promotions and their reuse intervals. |
| Stock | Presents data such as skuid, warehouseid, and totalquantity, providing information on the stock position of SKUs by warehouse. |
| Master Data | Contains fields like id, updatedin, and createdin, allowing management of entities and their dynamic properties. |
| Orders | Includes information such as orderid, status, and totalvalue, allowing detailed tracking of orders and their status. |
| Shipping Data of Orders | Provides shipping details including shippingestimateddate and shippingestimateddatemax, essential for logistical management. |
| Marketing Data of Orders | Includes information such as affiliateid and utmcampaign, allowing analysis of marketing campaigns associated with orders. |
| Order Details | Presents fields like lastmessageunread and callcenteroperatorname, offering insights into customer communication and service. |
| Logistics Information of Orders | Includes data such as invoiceinput and invoiceoutput, essential for managing fiscal and logistical documents. |
| Order Items | Contains information about each order item, such as totalitems and paymentnames, allowing detailed analysis of purchased products. |
| Payments: Order Transactions | Includes details about payment transactions, such as paymentnames and totalvalue, essential for financial control of orders. |
| Orders: Fees and Benefits | Includes information about fees and benefits associated with orders, such as totalvalue, shippingestimateddate, and paymentnames. |
| Orders: Totals | Presents the totals of orders, including orderid, totalvalue, and totalitems, along with details about the creation date. |
| Products | Contains data about available products, including skuid, warehousename, and totalquantity, along with pricing information. |
| Promotions | Provides details about promotions, including coupon_id, expirationintervalperuse, and maxitemsperclient, along with campaign information. |
| SKUs | Presents information about SKUs, such as skuid, totalquantity, and reservedquantity, along with data on stock availability. |
| SKUs: Kits | Includes data about SKU kits, allowing the visualization of product combinations along with their respective quantities and prices. |
| SKUs: Prices | Provides information about SKU prices, including skuid and pricing details, allowing for cost and promotion analysis. |
Try out all the features for free for 14 days
'%3E%3Cpath d='M51,41a9.978,9.978,0,0,0-7.857,3.835L22.648,34.588a9.69,9.69,0,0,0,0-5.176l20.5-10.247a10.1,10.1,0,1,0-1.791-3.577L20.857,25.835a10,10,0,1,0,0,12.33L41.352,48.412A9.994,9.994,0,1,0,51,41Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M33,47.645V60.71c.024-.014.05-.018.073-.033l11-7A2,2,0,0,0,45,51.992V40.012Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M31,47.645,19,40.011V51.992a2,2,0,0,0,.927,1.688l11,7c.023.015.049.019.073.033Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M32,21.693l12-7.634L33.076,7.086a2,2,0,0,0-2.152,0L20,14.059Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M12,35.556,0,27.922V39.9A2,2,0,0,0,.927,41.59l11,7c.023.014.049.019.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M52,35.556l12-7.634V39.9a2,2,0,0,1-.927,1.687l-11,7c-.023.014-.049.019-.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M47,38.914a2,2,0,0,0-.924-1.686L38,32.074V27.922l12,7.634V48.621c-.024-.014-.05-.019-.073-.033L47,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M13,33.821l12-7.634L14.076,19.214a2,2,0,0,0-2.152,0L1,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M17,38.914a2,2,0,0,1,.924-1.686L26,32.074V27.922L14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M32,45.91l12-7.634L33.076,31.3a2,2,0,0,0-2.152,0L20,38.276Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M14.076,19.214a2,2,0,0,0-2.152,0L1,26.187l12,7.634,12-7.634Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M49.924,19.214a2,2,0,0,1,2.152,0L63,26.187,51,33.821,39,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M26,27.922,14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726V38.914a2,2,0,0,1,.924-1.686L26,32.074Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M27.076,25.138A2,2,0,0,1,28,26.824V30.8l1.848-1.179A4,4,0,0,1,31,29.123V23.428L19,15.794v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M36.924,25.138A2,2,0,0,0,36,26.824V30.8l-1.848-1.179A4,4,0,0,0,33,29.123V23.428l12-7.634v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M33.076,31.3a2,2,0,0,0-2.152,0L20,38.276,32,45.91l12-7.634Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M50.348,42.573c0-9.411-8.691-12.336-16.348-14.416v-16.1a32.837,32.837,0,0,1,9.363,1.656l2.778,1.11,2.228-5.57L45.584,8.134A38.043,38.043,0,0,0,34,6.046V1H30V6.081c-8.213.594-16.348,4.86-16.348,13.471,0,9.036,8.841,11.732,16.348,13.744V50.074a33.591,33.591,0,0,1-12.006-2.511l-2.683-1.341-2.684,5.367,2.684,1.342c.243.121,5.7,2.792,14.689,3.152V63h4V56.065C44,55.462,50.348,50.3,50.348,42.573Zm-30.7-23.021c0-5.133,5.96-7.016,10.348-7.446V27.071C23.512,25.243,19.652,23.535,19.652,19.552ZM34,50.043V34.393c6.5,1.882,10.348,3.761,10.348,8.18C44.348,48.377,37.873,49.744,34,50.043Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)