improved

📝 Power BI: New Auth, Auto-Paging, and More Improvements

2 days ago

Release date: June 2025

🔐 New Authentication

Now get access token via auth.alvys.com/oauth/token for improved security and compliance.
Old authentication method will soon be disabled—update your credentials using the new setup instructions.

🔄 Automated Pagination

All queries now handle paging automatically.
Large datasets load completely, with no missing records or manual adjustments.
A built-in delay mechanism helps prevent hitting API rate limits during refreshes, improving reliability for large data pulls.

↔️ Nested Data Expansion

Data queries now automatically expand up to 3 levels of nested fields.
All relevant API data is accessible without extra manual steps.

🗓️ Automatic Field Type Conversion

Key fields such as dates and numbers are now automatically converted to the correct data types during import (e.g., date columns to datetime, amounts to numbers).
Ensures correct filtering, calculations, and visualization in your reports without manual adjustments.

📦 Loads Data Improvements

Loads are imported through two queries:
- Full Import
- Incremental Updates
Automatic deduplication ensures only the most recent update for each load is kept.

🧰 Consistent Query Structure

All endpoints (Loads, Trips, Users, etc.) now use a unified paging and expansion pattern.
Makes the model easier to understand, troubleshoot, and extend.

📊 New DAX & Reporting Features

Added several basic DAX formulas (e.g., simple sums, counts, or averages) to help users quickly analyze and familiarize themselves with their data.
Created a sample weekly summary report table—aggregates core metrics by week, making it easy to spot trends over time.
These examples are intended as a starting point for your own analysis—feel free to adjust or build on them as needed.

📘 Improved Onboarding

Step-by-step setup instructions are included to guide you through credential updates and data loading. You can find the link to the latest file and a quick onboarding guide here.

If you have questions or need help migrating, see the included instructions or contact your support team.