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 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. In addition, you must be on the October 2024 version of our 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. |
|
Custom Reports |
Access any Samsara custom report as a Power BI table, including Driver Safety Score and Vehicle Safety Score. Fields vary based on report design. Table range limited to 90 days. NoteContact your Samsara account representative to enable this table for your organization. |
Data heavy tables can 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.