> ## Documentation Index
> Fetch the complete documentation index at: https://docs.alvys.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Power BI Template File: Fast Setup Guide

> Fast-setup guide for the Alvys Public API.pbix template — load prebuilt queries, sample reports, and parameters into Power BI Desktop in minutes.

If you prefer to use a preconfigured file, you can import the `Alvys Public API.pbix` file, which contains all the latest queries, parameters, and sample reports to get you started quickly.

> ⬇️ Download: [Alvys Public API.pbix](https://drive.usercontent.google.com/u/0/uc?id=1ZdsauFy8KY9nHg1vykq5fNv4vE1Yl1Pq\&export=download)

***

#### **Steps to Get Started**

1. **Download and Open the File:**

   * Download the `Alvys Public API.pbix` file from the link above.
   * Open it in Power BI Desktop.

2. **Update Connection Parameters:**

   * Click on **Transform Data** from the top menu.
   * In the Transform Data view, go to **Manage Parameters** or select the parameter rows in the query list.

     <img src="https://mintcdn.com/alvys/MPqgFq1pceM5E4R4/images/migrated/186ea5eb3a70.png?fit=max&auto=format&n=MPqgFq1pceM5E4R4&q=85&s=7f6414cc631ae38f68ae8ff1bcf99df6" alt="" width="883" height="322" data-path="images/migrated/186ea5eb3a70.png" />
   * Update your `tenant_id`, `client_id`, and `client_secret` with your organization’s credentials (required for new Authentication flow).\
     *Note: Only newly generated credentials—with proper API scopes—are allowed in the new authentication flow. Legacy credentials will not work.*
   * *(The legacy authentication method will no longer be supported soon.)*

3. **Authenticate and Refresh:**

   * Select the `AccessToken` query and ensure a token is returned.

   * If prompted, click **Edit Credentials**, choose **Anonymous**, and click **Connect** with new endpoint `https://auth.alvys.com/oauth/token.`

   > ⚠️ Troubleshooting Authentication
   >
   > * Click on the AccessToken query.
   > * It should retrieve the authentication token automatically.
   > * If you see an "unauthorized" error or are prompted for credentials:
   >   * Click Edit Credentials
   >     * In the window that opens, select Anonymous authentication.
   >     * Confirm and click Connect.
   >     * After connecting, try refreshing the query again.

   * In Power Query, use **Refresh Preview** > **Refresh All** to refresh all queries with the new token and updated credentials.

     <img src="https://mintcdn.com/alvys/MPqgFq1pceM5E4R4/images/migrated/ba1797bf9346.png?fit=max&auto=format&n=MPqgFq1pceM5E4R4&q=85&s=36460c5a4635eafef7cd7a66c900699a" alt="" width="886" height="244" data-path="images/migrated/ba1797bf9346.png" />

   <br />

   > 🚧 Troubleshooting:
   >
   > If you see a “Formula.Firewall” or privacy error, go to File > Options and settings > Options > Privacy, and set to “Ignore the Privacy Levels.” This allows Power BI to combine data from multiple queries.

4. **Enable and View Data:**

   * In the Queries list, right-click any query you want to include in the report (e.g., Loads, Users, etc.).
   * For Loads and Trips, you will see multiple queries (e.g., 1 Loads - Search ALL, 2 Loads - Get Recent Updates, 3 Loads).
     * Important: Only the “final” combined query (usually 3 Loads or 3 Trips) should be enabled for load to the report. The “1” and “2” queries are used for data processing and should remain disabled after initial data validation.
     * Tip: If this is your first time setting up, you can temporarily enable the “1” and “2” queries to check the data. Once everything is working, disable them to keep your model clean and fast.
     * Right-click and select **Enable Load** to Report (or go to Properties and check "**Enable Load to Report**") for the queries you want visible in the report.
   * <img src="https://mintcdn.com/alvys/MPqgFq1pceM5E4R4/images/migrated/0d63e405ca4b.png?fit=max&auto=format&n=MPqgFq1pceM5E4R4&q=85&s=ac000f00988fe97ab66aac250f8e4003" alt="" width="736" height="563" data-path="images/migrated/0d63e405ca4b.png" />

5. **Apply Changes:**

   * Click **Close & Apply** in Power Query or go to **File > Apply Changes**.

6. **Explore Your Data and Reports**

   * In the Data view (left sidebar), you’ll see all your loaded tables along with a “DAX Report” table containing basic DAX formulas—these are included to help you quickly analyze or summarize your data.

     <img src="https://mintcdn.com/alvys/MPqgFq1pceM5E4R4/images/migrated/83bbff1be853.png?fit=max&auto=format&n=MPqgFq1pceM5E4R4&q=85&s=76f9c462c363faf600e641e2da5a122c" alt="" width="650" height="229" data-path="images/migrated/83bbff1be853.png" />
   * In the Report view (top icon on the left), you’ll find a sample weekly summary visualization and other quick-start report pages—these give you an instant overview and examples for analyzing your customer data.
   * To view your data, click any table in Data view to see all fields and records—then sort or filter columns directly to explore, check for errors, or find specific information; tip: sorting and filtering make it easy to spot updates or issues.
   * In the Model view (bottom icon on the left), you can review or adjust relationships between tables.\
     Tip: For accurate analysis, make sure to set a relationship between Loads (1) and Trips () using the LoadNumber field.

     <img src="https://mintcdn.com/alvys/MPqgFq1pceM5E4R4/images/migrated/691f5ed02f27.png?fit=max&auto=format&n=MPqgFq1pceM5E4R4&q=85&s=3857d0e014fc7d5d81a6a6c12107ce77" alt="" width="1914" height="814" data-path="images/migrated/691f5ed02f27.png" />
   * To update your data, go to Data view and click the three dots (...) next to a table to select Refresh data, or use Refresh all tables from the main menu to update everything; tip: refresh regularly to ensure you see the latest API data and parameter changes.

     <img src="https://mintcdn.com/alvys/MPqgFq1pceM5E4R4/images/migrated/d8a226736651.png?fit=max&auto=format&n=MPqgFq1pceM5E4R4&q=85&s=ba6a91803e5a23b3043d78d439a8eff0" alt="" width="1265" height="683" data-path="images/migrated/d8a226736651.png" />

   <br />

   <br />

***

*For more details or troubleshooting, see the instructions inside the file or contact your support team.*