How do I connect Loja Integrada to Power BI using Kondado?

Start by adding Loja Integrada as a data source in your Kondado account using your store credentials. Then select Power BI as your destination to establish the connection without any intermediate databases or complex configuration. The setup requires no technical expertise and typically takes just a few minutes to complete.

What Loja Integrada data can I visualize in Power BI?

You can replicate 17 different pipelines including Orders, Customers, Products, Coupons, Product Stock, and Order Status History into your Power BI dashboards. Each pipeline contains specific fields such as order values, customer emails, inventory quantities, and promotional codes that enable comprehensive store analytics. This data allows you to build custom reports covering sales performance, inventory management, and customer segmentation.

How often does Loja Integrada data update in Power BI?

Kondado updates your data on a configurable schedule that you control, with options ranging from every 5 minutes to daily intervals depending on your business needs. This automated refresh keeps your Power BI dashboards current without manual exports from your Loja Integrada admin panel. You can adjust the frequency anytime to balance between data freshness and processing requirements.

Can I track Loja Integrada sales performance by product category in Power BI?

Yes, by combining the Categories pipeline with Orders and Products data in Power BI , you can create visualizations showing revenue breakdowns across different product segments. This helps you identify which categories generate the most profit and deserve increased marketing investment. You can also analyze category performance trends over time to optimize your catalog strategy.

Is there a way to monitor Loja Integrada order fulfillment in Power BI?

Absolutely, using the Order Status History and Order Statuses pipelines, you can build Power BI dashboards that track orders from placement through delivery. This visibility helps operations teams identify bottlenecks in the fulfillment process and measure average processing times. You can set up alerts for orders stuck in specific statuses to improve customer service response times.

How do I share Loja Integrada dashboards with my team?

Once your data is in Power BI , you can distribute reports through Power BI Service by sharing links or embedding dashboards in your company's internal portals. Team members can view the latest Loja Integrada metrics without needing access to your store admin or Kondado account. This streamlined sharing ensures everyone works from the same updated data for consistent decision making.

Can I combine Loja Integrada data with other sources in Power BI?

Yes, Kondado allows you to replicate data from multiple sources into Power BI where you can join Loja Integrada sales information with marketing platforms or financial systems. This unified view helps you calculate true customer acquisition costs by connecting advertising spend with actual purchase data. You can also compare inventory data across multiple sales channels if you manage stores on different platforms.

What KPIs should I track for my Loja Integrada store in Power BI?

Essential metrics include conversion rates from the Orders pipeline, customer lifetime value from the Customers data, and inventory turnover using Product Stock information. You should also monitor average order value, coupon redemption rates, and shipping method performance to optimize operations. These KPIs in Power BI help you identify growth opportunities and operational inefficiencies quickly.

Connect Loja Integrada 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 Loja Integrada Data in Power BI

Connect your Loja Integrada store to Power BI to transform raw sales data into actionable business intelligence. With Kondado, you can replicate data from your Brazilian e-commerce platform directly into Power BI without complex technical setup or intermediate databases. This direct integration allows marketing teams and operations managers to monitor store performance through interactive dashboards that update automatically on your preferred schedule.

Kondado provides a direct integration between Loja Integrada and Power BI, offering 17 data pipelines with 397 fields including Orders, Products, Customers, and Coupons, enabling automated dashboard updates every 5 minutes to support data-driven decision making.

Business users can track revenue trends, analyze customer behavior, and optimize inventory management by visualizing Loja Integrada data in familiar Power BI reports. The platform requires no coding knowledge, making it accessible for SMBs and agencies that need professional analytics without technical overhead.

Our prices start from $19 USD/month, and you can try Kondado for free for 14 days with no credit card required

With your Loja Integrada data flowing into Power BI, you can combine information from the Orders and Product Stock pipelines to identify which items drive the most revenue while monitoring inventory levels automatically. Marketing teams gain powerful insights by analyzing the Customers and Coupons pipelines together to understand purchasing patterns and measure promotion effectiveness across different customer segments. Operations managers can also track Order Status History to optimize fulfillment workflows. These combined visualizations help you make informed decisions about restocking priorities, discount strategies, and customer retention campaigns without manually exporting spreadsheets from your store admin.

Try out all the features for free for 14 days

Loja Integrada data available in Power BI

available pipelines

397

extractable fields

Available integrations

Integration	Description
Categories	Includes fields such as id, name, and description, allowing for the organization and hierarchy of products in the store.
Customers	Contains information such as id, name, and email, along with contact details and communication preferences.
Customer Groups	Presents fields such as id, name, and whether it is a default group, facilitating customer segmentation.
Coupons	Includes fields such as id, code, and application conditions, allowing management of discounts and promotions.
Labels	Provides information about labels used to categorize products or customers, facilitating organization.
Shipping Methods	Presents details about available shipping methods, including id, name, and associated costs.
Payment Methods	Includes information about payment methods, such as id, name, and applicable fees for transactions.
Brands	Contains fields such as id, name, and description, allowing for the identification and organization of product brands.
Orders	Includes information such as id, status, and creation date, allowing for tracking and management of orders.
Order Status History	Presents a record of order status changes, including id, status, and date of change.
Order Invoices	Includes fields such as id, creation_date, and total_value, allowing detailed tracking of invoices generated for each order.
Products	Contains information such as id, name, and description, along with data on price and category, essential for managing the product catalog.
Product Stock	Presents fields such as product_id, available_quantity, and reserved_quantity, allowing effective control of the stock for each product.
Product Variation Grades	Includes fields such as product_id, variation_name, and variation_value, facilitating the management of different variations of the same product.
Product Images	Presents fields such as product_id, image_url, and image_description, allowing visual organization and presentation of product images.
Product Prices	Includes fields such as product_id, sale_price, and promotional_price, essential for defining and managing the sale prices of products.
Order Statuses	Presents fields such as id, description, and last_updated, allowing monitoring of the different statuses of orders in processing.

How to create Loja Integrada dashboards in Power BI

Visualize your data automatically — no spreadsheet exports or custom scripts.

Connect Loja Integrada as data source

Add Loja Integrada to your Kondado account by entering your store credentials to authorize data access. Select the specific pipelines you need, such as Orders, Customers, or Products, to begin replicating your store information.

Select Power BI destination

Choose Power BI as your destination and configure how you want your Loja Integrada data structured for visualization. Kondado will establish a direct connection that sends your selected pipelines directly into your Power BI workspace without intermediate steps.

Build dashboards and configure refresh

Create your custom reports in Power BI using the replicated Loja Integrada data and set your preferred update frequency. Choose from intervals like every 5 minutes, hourly, or daily to keep your business insights current automatically.