Connect Samsara data and third-party data into Microsoft Power BI to create KPI dashboards and uncover actionable business insights without having to write code.
For more information on how to integrate Samsara with Power BI and to view the currently supported data types available outside of beta, see Integrate with Power BI.
Table access corresponds to your API access, which is subject to your Samsara plan. For example, to access the IFTA table in Power BI, you will need the license named for the IFTA API (Tel-Prem). To review if any data type requires a specific license review Required Licenses for API and Webhooks Usage.
The connector provides a rich range of data that enables you to create dashboard or reports that fit your specific use cases. While these tables are in beta, a custom file path is required to access outside the published Samsara Connector. Reach out to your Samsara account team to request beta access to the data types in the following table:
|
Data Type |
Fields |
|---|---|
|
Assets |
Asset ID, Name, Serial Number, Type, Make, Model, Year, VIN NoteContact your Samsara account representative to enable this table for your organization. |
|
Coaching Sessions |
Session ID, Driver, Assigned Coach ID, Coachable Behavior Type, Behavior Note, Behavior Last Coached, Coaching Type, Session Status, Session Note, Session Updated At |
|
Driver Coach Assignments |
Driver ID, Coach ID, Assignment Created At, Updated At |
|
Devices |
Asset ID, Health Status, Last Connected, Cellular Data Used, Hotspot Usage, Model, Serial |
|
Driver Vehicle Assignments |
Driver ID, Vehicle ID, Assignment Type, Assigned At Time, End Time, Source Name, Passenger Status |
|
Documents |
Document ID, Document Type, Document Name, Notes, Route ID, Route Stop ID, Driver ID, Vehicle ID, Created At Time, Updated At Time |
|
Document Conditional Fields |
DocumentID, Conditional Field First Index, Last Index, Triggered Field Index, Value |
|
Document Fields |
Document ID, Field Type, Label, Value {BarcodeType, Barcode; DateTime; MultipleChoiceSelected, Value; Number; Photo URL; Scanned Document URL; Signature Name, Signed At Time, Signature URL; Text} |
|
DVIR Defects |
Vehicle ID, Trailer ID, Defect Type ID, DVIR ID, Defect ID, Created At Time, Is Resolved, Resolved At Time, Resolved By, Mechanic Note, Comment |
|
DVIRs |
Vehicle ID, Trailer ID, Type, Submission Begin Time, Submission Time, Updated Time, Signed At Time, Signature ID, Formatted Address, Mechanic Notes, Odometer, Safety Status |
|
DVIR Defect Types |
Defect ID, Label and Section |
|
HOS Daily Logs |
Driver ID, Vehicle ID, Start Time, End Time, Drive Distance, Personal Conveyance Distance, Yard Move Distance, Duty Status Durations, Certification Status, Certified Time, Claims, Carrier information, Home Terminal Address, Shipping Docs, more |
|
HOS Logs |
HOS Logs ID, Driver ID, HOS Status Type, Log Start Time, Log End Time, Lat/Long, Vehicle ID, Remark |
|
HOS Violations |
Type, Description, Driver ID, Start Time, End Time, Duration, HOS Violation ID |
|
Route Stops |
Route ID, Route Stop ID, Scheduled Start Time, Scheduled End Time, Actual Start Time, Actual End Time, Skipped Time, Route Stop State, Address ID, Location Lat/Long, Location Street Address, Route Stop ETA, Route Stop Name, Notes |
|
Routes |
Route ID, Route Name, Notes, Driver ID, Asset ID, Scheduled Start Time, Scheduled End Time, Actual Start Time, Actual End Time |
Some tables, such as HOS Daily Logs, can take longer to load depending on the window of data selected (up to 6 months of data). Driver Vehicle Assignments and other similarly data heavy tables can also take awhile to load. In such cases we recommend an async scheduled refresh or limiting the query window.
Comments
0 comments
Article is closed for comments.