Importing the Preconfigured Alvys Public API.pbix File

If you prefer to use a preconfigured file, you can import the Alvys Public API.pbix file, which contains all the queries described in this guide, including the AccessToken query. This file simplifies the setup process by providing ready-to-use queries for interacting with the Alvys Public API.

⬇️

Download: Alvys Public API.pbix

Steps to Use the Preconfigured File

1. Download and Open the File:
   • Obtain the Alvys Public API.pbix file from the source above.
   • Open it in Power BI Desktop.
     
     
2. Update the AccessToken Query:
   • Navigate to the Transform Data view.
   • Locate the AccessToken query in the Queries pane.
   • Replace the credentials (tenant_id, client_id, and client_secret) with your own API credentials.
   • Important Note: Ensure the "&" at the end of the credentials in the AccessToken query remains intact, as it is required for the proper construction of the request.
     
     
3. Save and Refresh:
   • After updating the credentials, save the changes and refresh the queries.
   • The file will now fetch data dynamically using your credentials.
     
     
4. Authentication and Global Permissions:
   • The first time you attempt to connect to the Alvys API in Power BI, you will be prompted to authenticate. Follow the steps for **Authentication and Global Permissions here.**