Microsoft Power BI Configuration Guide

Transform your Lytx fleet data into interactive Power BI dashboards. Create real-time visualizations, automated reports, and advanced analytics with seamless data connectivity.

Pre-requisites

• Power BI Desktop (latest version) or Power BI Pro/Premium license
• Windows 10/11 (Power BI Desktop)
• Lytx Data Connector credentials
• 8GB RAM minimum (16GB recommended for large fleets)

Configuration Guide

1. Under the Data ribbon tab, select Get data.
2. Select OData Feed. If you are unable to find OData feed from this selection, select More… under the data sources, select Other from the left navigation menu, and then select OData Feed.
3. Select the Basic radio button.
4. Enter the connector URL:
   Copy

   Copied

   https://api.lytx.com/data/v1/odata

5. When prompted for authentication, select Basic from the left navigation menu.
6. Enter your credentials:
   • Username: DB_NAME/Your_Connector_Username
   • Password: Your_Connector_Password
7. Select which level to apply these settings to: do not modify this
8. Click Connect to view the available data resources.
9. From the Data Navigator, select all the relevant tables and resources that you would like to import
10. Click Load to import the data as-is, or press Transform Data to transform and alter the data before loading it into the Power BI data model.