Connect Power BI to the Alvys Public API to enable dynamic data retrieval for creating reports and visualizations. This connection allows for advanced data searches using POST methods, providing enhanced filtering capabilities, date range selection, and status-based queries that go beyond basic reporting.

This integration unlocks powerful analytics capabilities for your operation. You can use POST methods for detailed searches including filters and date ranges, retrieve data in real time to create up-to-date Power BI dashboards, and leverage Power BI's visualization tools to represent Alvys data effectively.

With access to endpoints like Loads, Drivers, Fuel, Invoices, Trips, Trucks, and more, you can explore data across multiple operational areas and generate insightful analytics tailored to your specific needs.

To set up the connection, you'll need your Alvys API Credentials including Client ID, Tenant ID, and Client Secret. Obtain these from the Alvys Platform under Profile > API.

You'll also need Power BI Desktop with the latest version installed. Configure settings to disable privacy checks for smooth API integration. Finally, generate an API token for authenticating your requests to Alvys API endpoints.

For detailed instructions on setting up and configuring your connection, refer to our Alvys Public API Documentation. This comprehensive guide includes setup instructions, query examples, and a preconfigured Power BI file for quick integration.

Once connected, you can query various endpoints to retrieve data. The Loads Search endpoint lets you filter loads by criteria such as date, status, and more. Drivers Search allows you to query driver details based on fleet or status. Fuel Search provides access to transaction histories, while Invoices Search lets you retrieve invoice data by date or status.

Q: Can I use Power BI to connect directly to Alvys API?

A: Yes, the Alvys Public API supports integration with Power BI, enabling both GET and POST methods for retrieving data.

Q: Why use POST methods with Power BI?

A: While GET requests allow basic data retrieval, POST methods unlock advanced search capabilities, including filtering by status or date ranges.

Q: Where can I find my API credentials?

A: API credentials (Client ID, Tenant ID, Client Secret) are available under Profile > API on the Alvys platform.

Alvys Public API Documentation