Unlock powerful data visualization with ActivTrak for Power BI - Customizable ActivTrak Reports. This guide walks you through the simple setup process of connecting your ActivTrak data to Microsoft Power BI through ActivConnect. Access, analyze, and visualize millions of rows of data using familiar tools like formulas, charts, and pivot tables while keeping your data current through scheduled refreshes.
ActivConnect is available as an add-on for customers on a paid plan. Learn more about ActivConnect here.
Contents
- Template access requirements
- Access the template
- Download the Power BI Desktop File (Optional)
- Learn more
Template access requirements
Before you begin, ensure you have:
- An ActivTrak paid plan and the ActivConnect API (Add-on).
- Your ActivConnect username ([account_number]@activtrak.us) and password. Your account number is in the Account Information menu in ActivTrak; access it via the circle icon in the top right corner.
- An active Power BI license.
Note: While this template is designed to work with all ActivTrak paid plans, the data available for each report will vary based on your specific plan type. Reports with the Premium or Professional label in the report title indicate that the necessary data for those reports is available only to those license tiers.
Access the template
Validate your ActivConnect credentials
- Navigate to Google Cloud Console.
- Log in with your ActivConnect username ([account_number]@activtrak.us) and password.
Install Power BI
- Within the ActivTrak app, navigate to APIs & Integrations > ActivConnect & BI.
- Find the Customizable ActivTrak Reports card and click the Get it from Microsoft AppSource icon.
- The Microsoft AppSource ActivTrak for Power BI page will open - click the Get it now button.
- Power BI will open, and a pop-up window will appear - click the Install button.
- The template will load with sample data.
- In the yellow notice bar at the top, click Connect your data.
- Enter your ActivTrak account number and Healthy Device Threshold (in number of days). Your account number is in the Account Information menu in ActivTrak; access it via the circle icon in the top right corner.
- Click the Next button.
- A Connect to ActivTrak for Power BI window will appear - click the Sign in and connect button.
- A Sign in with Google window will appear - select your ActivConnect credentials (the same credentials from the Validate your ActivConnect credentials step).
- On the Power BI Desktop wants to access your Google Account window, click the Allow button.
- The data refreshment may take a few minutes.
Download the Power BI Desktop File (Optional)
- Click the pencil icon in the top right corner of the Power BI application, and click the Yes, go to workspace button if prompted.
- Select the ActivTrak for PBI Report file.
- From the File menu, click Download this file.