SysTrack Power BI Connector

SysTrack collects over 10,000 pieces of data every 15 seconds. However, that much data can be overwhelming when you need to produce a report. Learn how to download and configure the SysTrack Power BI Connector so you can then use Microsoft Power BI to showcase SysTrack data in the best way possible.

NOTE: This course assumes that you know how to use Power BI and have access to your SysTrack cloud tenant. If you have an on-premises SysTrack installation, you do not need the SysTrack Power BI Connector as you will use the SQL database connector.

This course does not provide instruction on using Power BI Desktop or for connecting Power BI to a SQL database.

There is no certification exam for this course. You will receive a Certificate of Completion at the conclusion.

Sign in  as a SysTrack customer to start this course.

Prerequisite

  • Power BI knowledge

  • SysTrack Administrator course (for information on using Configure)

Recommended (to practice the topics covered in this course):

  • Power BI Desktop

  • Access to your SysTrack cloud tenant

Course Objective

Learn how to download and configure the SysTrack Power BI Connector so you can then create Power BI reports that include SysTrack data.

Course Outline

  • Introduction
    • Course Overview
    • Microsoft Power BI
  • Setting It Up
    • Configuring the Power BI Connector
      • Importing the Kit
      • Using an automation to install the certificate
      • Download and copy PQX file
      • Testing the connection
      • SysTrack tools used:
        • Kits
        • Configure: Automations and Collection Extensions
        • Configure: Administration > Read Configuration
        • Resolve: Tools > Run Automations
        • Admin Panel: Tenant Information
  • Templates and Reports
    • Power BI Connector Datasets
      • Adding Lakeside datasets
    • Creating Templates and Reports

Tags: Configure, Power BI, Reporting