Overview
You can 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. With this integration, you can access endpoints such as Loads, Drivers, Fuel, and more, making it easier to generate insightful analytics tailored to your needs.
Key Benefits
Advanced Queries: Use POST methods for detailed searches, including filters and date ranges.
Dynamic Data Access: Retrieve data in real-time to create up-to-date Power BI dashboards.
Custom Visualizations: Leverage Power BI’s visualization tools to represent Alvys data effectively.
Getting Started
To set up the connection, you will need:
Alvys API Credentials: Obtain your Client ID, Tenant ID, and Client Secret from the Alvys Platform under Profile > API.
Power BI Desktop: Install the latest version and configure settings to disable privacy checks for smooth API integration.
Access Token: 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.
Available API Endpoints
Once connected, you can query various endpoints to retrieve data, including but not limited to:
Loads Search: Filter loads by criteria such as date, status, and more.
Drivers Search: Query driver details based on fleet or status.
Fuel Search: Access transaction histories.
Invoices Search: Retrieve invoice data by date or status.
Trips, Trucks, and More: Explore data across multiple operational areas.
Additional Resources
To learn more about how to configure Power BI with the Alvys Public API and create advanced queries, visit our API Documentation. This resource provides a comprehensive guide, including setup instructions, query examples, and a preconfigured Power BI file for quick integration.
FAQ
Can I use Power BI to connect directly to Alvys API?
Yes, the Alvys Public API supports integration with Power BI, enabling both GET and POST methods for retrieving data.
Why use POST methods with Power BI?
While GET requests allow basic data retrieval, POST methods unlock advanced search capabilities, including filtering by status or date ranges.
Where can I find my API credentials?
API credentials (Client ID, Tenant ID, Client Secret) are available under Profile > APIon the Alvys platform.