Learn how to integrate your existing Dashpivot Daily Timesheet templates with Power BI using Sitemate’s Flowsite. Flowsite automatically transfers timesheet data from Dashpivot into Excel and Power BI, helping teams streamline payroll reporting, workforce tracking, and project analysis without manual data entry.
Daily timesheets are used to record the hours worked by individuals, crews, or plant on a daily basis. These templates may include sign-in and sign-out times, breaks, total hours worked, allowances, cost codes, and activity details. By connecting existing Dashpivot templates to Power BI through Flowsite, teams can bring together and automate timesheet reporting processes.
Benefits of integrating Dashpivot Daily Timesheets with Power BI
Eliminate Manual Data Entry – Timesheet data is automatically transferred to Power BI, reducing the risk of human error and saving significant administrative time.
Faster Payroll Processing – Keep payroll and timesheet records aligned and avoid duplicated or missing hours.
Improved Accuracy – Automated integration ensures consistency between the Timesheet form entries and payroll records, helping avoid issues like duplicated hours or missing data.
Custom Reporting – Build tailored dashboards for hours worked, overtime, allowances, cost codes, and project tracking.
Scalability – Manage increasing project and workforce data without adding administrative overhead.
Features of Daily Timesheets
Daily Timesheet templates in Dashpivot capture detailed daily work information for employees, crews, or plant. Hours are typically captured using a table field and automatically transferred to Power BI using Flowsite.
1. Unified Timesheet Data
Create one master dashboard to display:
Daily hours per employee or plant
Projects
Cost codes
Dates
Start and finish times
Total hours worked
Activity details
2. Custom Filters
Easily filter timesheet records by:
Employee or plant
Project
Date
Task or location
Allowances
This enables quick summaries and reviews of daily work logs.
Note: There may be instances when manual manipulation of data is required such as data not found or sourced from Dashpivot, you might need manual manipulation of data we need to link an excel file to Power BI for the manual entry corrections. Contact Support if your have any questions.
How to set up the integration
1. Connect Dashpivot to Flowsite
Log in to Flowsite.
Navigate to Connections.
Find Dashpivot and select Connect.
Enter your Dashpivot credentials and authenticate the connection.
Confirm the connection appears in your Connections table.
Tip: Correctly configuring your Dashpivot data structure helps prevent formatting and mapping issues in Excel and Power BI.
Tip: Configure your Dashpivot data correctly to avoid errors in your Excel file.
2. Create a flow
Select your Daily Timesheet template in Dashpivot.
Choose Excel as the destination.
Set the recurring sync schedule in the Flow Editor (for example, hourly or daily).
See also:
3. Configure your Excel file
Select or create the Excel workbook.
Structure and format the required columns, such as:
Employee
Date
Hours worked
Cost code
Allowances
Project
4. Test the workflow
Submit a sample timesheet in Dashpivot.
Trigger the flow manually.
Confirm the data appears correctly in Excel and Power BI.
Example Dashboard
