Dashboards in minutes

Connect Sólides DP to Power BI: Dashboards in Minutes

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

sso google logo
Sign up with Google
sso facebook logo
Sign up with Facebook
sso microsoft logo
Sign up with Microsoft
sso linkedin logo
Sign up with Linkedin

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

Connect Sólides DP to Power BI

To visualize Sólides DP data in Power BI, connect your time clock system to Kondado and select Power BI as your destination. Kondado replicates your attendance records and employee information directly into Power BI, enabling you to build custom dashboards without technical complexity. You can configure updates to run every 5 minutes, hourly, or daily based on your business needs, ensuring your reports reflect current workforce data.

13
available pipelines
276
extractable fields
  • ✓No code, no spreadsheets
  • ✓Auto-refreshed data
  • ✓14-day free trial

Try out all the features for free for 14 days

Kondado provides a direct connection between Sólides DP and Power BI that delivers 153 data fields across Daily Summary and Employees pipelines, allowing teams to monitor attendance patterns and workforce productivity through automated reports.

This approach eliminates manual data exports and gives operations teams immediate access to visual insights for scheduling decisions and labor cost analysis. Business users can track worked hours, overtime trends, and employee attendance metrics through intuitive visualizations that support daily operational planning.

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

Try out all the features for free for 14 days

Available data

Sólides DP data available in Power BI

Each item below is automatically replicated by Kondado from Sólides DP into Power BI — no schema setup, no manual mapping.

13
available pipelines
276
extractable fields
∞
Auto-refresh

Available integrations

Daily Summary
Includes information such as worked hours, paid hours, and compensatory hours. Fields like id, employeeid, and isholiday help analyze employee attendance.
Employees
Contains data about employees, including name, email, and admission date. Fields like id, jobroledto__id, and birthdate provide essential details about each employee.
Time Clock Records
Employee clock-in and clock-out punches, one per row, with date and time, entry and exit geolocation, workplace, and adjustment and validation flags (fingerprint, facial recognition).
Time Adjustments (incl. vacations and leaves)
Time adjustments such as vacations, medical certificates, days off, and excused absences. Each row has the period, reason, employee, and approval status, useful for tracking justified absences.
Adjustment Reasons (incl. vacations and leaves)
Registered adjustment reasons, such as vacation, medical certificate, day off, and excused absence. This is the table that classifies time adjustments.
Job Roles
Company job roles, with description, CBO (Brazilian occupation code), and base salary.
Work Schedules
Registered work schedules (shifts), one per row, to compare the planned workday with the recorded hours.
Workplaces
Workplaces (departments and units), active and inactive, to analyze attendance and hours by unit.
Managers
Registered managers and their matching employee record, to build attendance analysis by team and leadership.
Companies (branches)
Registered companies (headquarters and branches, by CNPJ). Employees point to their company through the company__id field, so attendance and hours can be analyzed by branch.
Time Clock Rules
Registered time clock rules: tolerances, night hours, hour bank vs. overtime control, and hour bank percentages and limits.
Hour Bank (current balance)
Current hour bank balance for each employee at read time. The table is rewritten on every run, as a snapshot of the balance, without history.
Time Edit Justifications
Justifications available for manually editing clock punches, with the attachment and note requirements of each one.

Try out all the features for free for 14 days

With Sólides DP data flowing into Power BI through Kondado, you can transform raw time clock records into actionable workforce intelligence. The Daily Summary pipeline brings worked hours, paid hours, and compensatory time into your dashboards, while the Employees pipeline adds essential context with admission dates and job roles. Combine these datasets to identify attendance trends, track overtime costs, and optimize shift scheduling based on actual productivity patterns rather than estimates. Operations managers can spot absenteeism patterns early and make data-driven decisions about staffing levels across departments.

Try out all the features for free for 14 days

How to create Sólides DP dashboards in Power BI

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

1
Connect Sólides DP as data source

Log into Kondado and add Sólides DP as a new data source, entering your account credentials to establish the connection.

2
Select Power BI destination

Choose Power BI as your destination and configure which pipelines you want to replicate, such as Daily Summary and Employees.

3
Configure refresh and build dashboards

Set your preferred update frequency from 5 minutes to daily, then start building custom attendance reports and workforce analytics in Power BI.

Access Sólides DP data in Power BI and combine it with dozens of other data sources

If the source you want is not listed, drop us a chat message. We love to add new sources!

Visualize Sólides DP data in other BI tools

If the software you need is not listed, drop us a messagem. You can use almost every tool

Hundreds of data-driven companies trust Kondado
arezzo
brf
Contabilizei
dpz
Experian
grupo_soma
multilaser
olist
unimed
v4_company
webmotors
yooper

Frequently Asked Questions (FAQ)

Answers about visualizing Sólides DP data in Power BI automatically

How do I connect Sólides DP to Power BI without coding? ▼
Add Sólides DP as a data source in your Kondado account and authenticate with your credentials. Then select Power BI as the destination to start replicating your attendance data automatically.
What attendance KPIs can I track in Power BI with Sólides DP data? ▼
You can monitor worked hours versus paid hours, track compensatory time balances, analyze holiday attendance patterns, and measure employee punctuality trends. The Daily Summary pipeline provides specific fields like isholiday and compensatory hours to build these metrics.
How often does Sólides DP data update in my Power BI reports? ▼
Kondado updates your data on a configurable schedule that you control, with options ranging from every 5 minutes to daily intervals. This keeps your workforce reports current without requiring manual refreshes or exports from Sólides DP.
Can I share Sólides DP attendance dashboards with my team? ▼
Yes, once your data is in Power BI, you can distribute reports to managers and HR teams through Power BI's native sharing features. This ensures everyone views the same attendance metrics and scheduling insights.
Do I need a pre-built template to visualize Sólides DP data? ▼
No pre-built templates are required. You can create custom dashboards in Power BI using the 153 available fields from the Daily Summary and Employees pipelines to match your specific workforce analysis needs.
What is the Via Kondado connection method for Sólides DP? ▼
Via Kondado creates a direct link between your time clock system and Power BI without intermediate databases or complex IT setup. This method streams your employee attendance data directly into your visualization tool for immediate analysis.
Can I combine Sólides DP data with other business data in Power BI? ▼
Yes, you can blend Sólides DP attendance records with data from other sources like Google Sheets or BigQuery within Power BI. This allows you to correlate workforce hours with sales performance or project budgets.

Try out all the features for free for 14 days