*STOP - Before going through this guide step-by-step, you will need your ActivTrak.us domain account made first. You should have received a welcome email with the following information:
What you need to get started-
- Project Name
- Data Set
- View Name
- Group View Name: (usergroups)
If you did not receive this information and are unsure of whether or not this has been completed for you, please contact [email@example.com] or open a chat through the dashboard.
Grab the Template-
1. Log into your ActivTrak dashboard.
2. Navigate to the Integrations tab.
4. Click All the above under Microsoft Teams.
5. The template will now start downloading.
Extraction and Data download setup-
1. Go to your downloads folder on your computer.
2. Right-click on the ActivTrak-for-Ms-Teams-All-of-the-above.zip.
3. Extract the folder.
4. Double click on the ActivTrak for MS Teams.pbix template.
5. Power BI Desktop will open.
6. Once opened a window will appear.
7. You will need to enter the correct information into the fields. (Reminder, the first three are listed in your welcome email)
- GroupViewName: usergroups
- TimeZone: will be + - your time zone (Example: For Central Time, you would enter “-5” without the quotes this is central time -5)
- DaylightSavings: False
- FocusedTime - Max Distinct Apps: 2
- FocusedTime - Max Distinct Screens: 4
- Inactive Agent: 72
8. Click the yellow load button.
9. At the bottom you will see the data that was imported in and it will be 14 tabs.
10. At the top right, you may need to click refresh.
11. Click on one of the tabs of data that was imported for example the Productivity Trend and double-check you see data. If you do see data, proceed.
NOTE: If you do not see data or are getting an error connecting, please open a chat or email firstname.lastname@example.org. Remember to please attach relevant screenshots of the error(s).
Push out your data to Power BI online-
NOTE: In order to publish a report to PowerBI’s Online service, you must own a license to PowerBI. Those with a free license of PBI may have limited functionality when sharing or using other features in their online PowerBI portal.
For more information on the differences between the types of PowerBI Licenses, please review the following information. Power BI licensing for users in your organization - Power BI
1. Click Publish.
2. A window will appear asking if you want to save your changes.
3. Click Save.
4. Another window will open saying “There are pending changes in your queries that haven’t been applied. Do you want to apply them?”
5. Click Apply later.
6. Click Publish again at the top. (So you have a local copy to modify)
7. A window will open.
8. Enter a File name: into the field.
9. Click Save.
10. Then a window will appear asking you to select a destination.
11. Click My workspace.
12. Click Select.
13. You will now see this:
Go to Power BI-
1. Click on workspaces on the left-hand side. (the little arrow)
2. Click on My workspace next above the search bar.
3. You will now see the report you created.
4. You will now see the same reports (tabs):
5. Navigate to Datasets.
6. Click on the ellipsis next to the name of the data set.
7. Click on Schedule refresh.
5. You will now see this screen. (Keep in mind that where it says Support account, yours will be different and will say the name of your data set.)
6. Click on Data source credentials.
7. Click on edit credentials.
8. A new window will appear, do not change anything and click sign in.
9. You will now be asked to re-authenticate through Google (Sign-in).
10. Click Allow.
11. Under schedule refresh click On where it says Keep your data up to date.
12. Keep Refresh frequency as Daily.
13. Under Time, click Add another time.
NOTE: we refresh our data twice a day so for example in Central Time we will schedule at 5 am and 5 pm, please change this accordingly.
14. Add two times to refresh.
15. In the email field below, you can add additional people to receive the refresh failure notification email. (by default, it will be the publisher of the report who receives the refresh failure email)
16. Click Apply.
NOTE: Example email is shown below:
NOTE: On the screenshots below, the New look on is turned on, so if you do not have yours on, it will look different.
1. Click Share at the top.
2. This window will appear.
3. Under "Grant access to", enter in the emails you want to share the report to.
4. Copy the report link and click Share.
NOTE: no one will be able to access the report until you grant them access. When they do try to access the report and do not have access, you will receive an email.
*You can click the Grant access button in the email to also give them access if you are an admin. It will take you to the access page, which is a tab on the share report.
*When you grant access to a person, default is Read-only.
Refresh if you are viewing in Power BI online-
1. Click on the ellipsis.
2. Click Refresh.
Microsoft Teams time-
*Note- You will need a team set up for this. To do this, click on Join or create a team, and then click create a new team.
1. Log into your MS Teams account.
2. Click teams on the left.
3. You will need to click on your team under Your teams.
4. Click on General.
5. Click on the + (Plus sign).
6. Search for “Power BI” if you do not already see it (you need a space between the Power and the BI for it to come up).
7. A new window will appear under My workspace, click the team you made.
8. Click Save.
NOTE: You will now see the data, an example is shown below and you can see the different report tabs as well at the bottom.
NOTE: It may take the report a few minutes to load as well.
Was this article helpful?
1 out of 1 found this helpful