How do I connect Tiny ERP to Power BI without technical setup?

Start by adding Tiny ERP as a data source in your Kondado account and authenticate your credentials. Then select Power BI as your destination and choose the specific pipelines you want to replicate, such as Orders or Invoices. The "Via Kondado" connection handles the technical details automatically, so you can begin building reports immediately without managing databases or writing code.

What pre-built dashboard templates are available for Tiny ERP and Power BI?

Kondado offers ready-made report templates including the Olist Tiny Power BI Report and the Olist Tiny Looker Studio Report. These templates provide immediate visualizations for common business scenarios like sales performance and financial tracking, allowing you to start analyzing your data within minutes rather than building dashboards from scratch.

How often does Tiny ERP data update in Power BI reports?

You control the refresh schedule based on your business needs, with options ranging from every 5 minutes to daily updates. For fast-moving ecommerce operations, near-real-time updates every 15 minutes keep inventory and order data current, while financial reports might work well with hourly or daily refreshes depending on your reporting requirements.

Which KPIs should I track when visualizing Tiny ERP data in Power BI?

Focus on metrics that combine your Accounts Receivable and Order Details pipelines to monitor cash flow health and sales velocity. Track days sales outstanding, inventory turnover using Product Inventory data, and customer lifetime value by analyzing Contacts alongside purchase history. These insights help identify which products drive profitability and which customers warrant priority attention.

Can I share Tiny ERP Power BI dashboards with my team?

Yes, once you build your reports in Power BI , you can distribute them to stakeholders across your organization using Power BI's native sharing features. Your marketing team can view campaign performance while your finance team monitors accounts payable, all working from the same automatically updated data source without needing direct access to Tiny ERP.

What types of businesses benefit most from connecting Tiny ERP to Power BI?

Online stores, retail chains, and service companies using Tiny ERP for daily operations gain significant value from visualizing their unified data. Businesses managing multiple sales channels particularly benefit from combining ecommerce marketplace data with traditional retail metrics to get a complete view of performance across all touchpoints.

Can I send Tiny ERP data to other tools besides Power BI?

Absolutely, Kondado allows you to replicate your Tiny ERP data to multiple destinations simultaneously. You can send information to Google Sheets for quick team collaboration, BigQuery for advanced analysis, or Looker Studio for alternative visualization options while maintaining your primary Power BI reports.

Connect Tiny ERP 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 Tiny ERP Data in Power BI

Want to turn your Tiny ERP data into actionable business intelligence? Kondado connects your Tiny ERP directly to Power BI, letting you build dynamic reports and dashboards without technical complexity. Simply select which data you want to replicate, choose your update schedule, and start visualizing your ecommerce, financial, and operational metrics in minutes.

Kondado provides a direct integration between Tiny ERP and Power BI through a “Via Kondado” connection, eliminating the need for intermediate databases or complex technical setup while keeping your reports updated on a configurable schedule.

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

Combine your financial and sales data from Tiny ERP to uncover insights that drive smarter business decisions. By replicating Accounts Receivable and Order Details into Power BI, you can track which products generate the most revenue, identify late payments affecting your cash flow, and analyze customer purchasing patterns across different sales channels. Marketing and operations teams benefit from having Product Inventory and Contacts data readily available, enabling them to coordinate stock availability with promotional campaigns and segment customer communications based on purchase history.

Try out all the features for free for 14 days

Tiny ERP data available in Power BI

available pipelines

792

extractable fields

Available integrations

Integration	Description
CRM Issues	Includes fields such as assunto_id, assunto_cliente, and assunto_data_acao, enabling tracking of the stage and status of each issue.
CRM Issues Details	Presents detailed information such as cliente_codigo, cliente_nome, and cliente_endereco, facilitating the analysis of associated contacts.
Accounts Payable	Contains records with id, data_emissao, and valor, allowing control over accounts payable and their respective statuses.
Accounts Receivable	Includes fields such as id, data_emissao, and saldo, facilitating the management of accounts receivable and their history.
Contacts	Contains information such as cliente_id_cliente, cliente_nome, and cliente_fone, allowing effective management of contacts.
Accounts Payable Details	Includes fields such as id, data_vencimento, and situacao, allowing detailed tracking of accounts payable.
Accounts Receivable Details	Presents information such as id, data_vencimento, and saldo, facilitating control over accounts receivable.
Invoice Details	Includes fields such as id, data_emissao, and historico, allowing detailed tracking of issued invoices.
Invoice Details: XML	Presents information in XML format, including fields such as id and tax data, facilitating integration with external systems.
Order Details	Includes fields such as id, data_pedido, and valor_total, allowing detailed tracking of placed orders.
Product Inventory	Table provides information about inventory, including fields such as id, product name, and available quantity.
Invoices	Table contains details of invoices, featuring fields such as id, issue date, and customer name.
Orders	Table lists the orders placed, including fields such as order id, order date, and status.
Products	Table presents information about products, with fields such as id, name, and price.
Product Grid	Table provides a detailed grid of products, including fields such as id, description, and category.

CRM Issues

Includes fields such as assunto_id, assunto_cliente, and assunto_data_acao, enabling tracking of the stage and status of each issue.

CRM Issues Details

Presents detailed information such as cliente_codigo, cliente_nome, and cliente_endereco, facilitating the analysis of associated contacts.

Accounts Payable

Contains records with id, data_emissao, and valor, allowing control over accounts payable and their respective statuses.

Accounts Receivable

Includes fields such as id, data_emissao, and saldo, facilitating the management of accounts receivable and their history.

Contacts

Contains information such as cliente_id_cliente, cliente_nome, and cliente_fone, allowing effective management of contacts.

Accounts Payable Details

Includes fields such as id, data_vencimento, and situacao, allowing detailed tracking of accounts payable.

Accounts Receivable Details

Presents information such as id, data_vencimento, and saldo, facilitating control over accounts receivable.

Invoice Details

Includes fields such as id, data_emissao, and historico, allowing detailed tracking of issued invoices.

Invoice Details: XML

Presents information in XML format, including fields such as id and tax data, facilitating integration with external systems.

Order Details

Includes fields such as id, data_pedido, and valor_total, allowing detailed tracking of placed orders.

Product Inventory

Table provides information about inventory, including fields such as id, product name, and available quantity.

Invoices

Table contains details of invoices, featuring fields such as id, issue date, and customer name.

Orders

Table lists the orders placed, including fields such as order id, order date, and status.

Products

Table presents information about products, with fields such as id, name, and price.

Product Grid

Table provides a detailed grid of products, including fields such as id, description, and category.

See all available data →

Try out all the features for free for 14 days

Discover our Tiny ERP report in Power BI

How to create Tiny ERP dashboards in Power BI

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

Connect Tiny ERP to Kondado

Add Tiny ERP to your Kondado account by entering your API credentials and selecting the specific pipelines you need, such as Orders or Accounts Receivable.

Select Power BI destination

Choose Power BI as your visualization tool and configure how you want your Tiny ERP data structured for analysis.

Build dashboards and configure refresh

Create your reports in Power BI using the replicated data and set your preferred update frequency to keep insights current without manual intervention.