Power BI Extract
  • 06 Jul 2022
  • 2 Minutes to read
  • Dark
    Light
  • PDF

Power BI Extract

  • Dark
    Light
  • PDF

SysAid’s Power BI Extract integration allows you to regularly export your SysAid SR data to OneDrive where you can display it in MS PowerBI.

PowerBI Extract video

Licensing

You can contact your account manager to purchase a license or a 30-day trial license for this add-on.

Set up the Power BI Extract add-on

  1. From the SysAid Marketplace, get the Power BI Extract add-on.
  2. On the main My Apps page, in the Power BI Extract icon, click IntegrationsfilesGreenCog14.jpg.
  3. Regitster the application in Azure
    1. In the Azure dashboard, click App Registrations.
    2. Click View All Applications.
    3. Click New Registration.
      IntegrationOffice365NewRegistrationNewRegistration3.jpg
    4. In the Name field, enter a name for the application (for example "SysAid BI").
    5. Click Register.
      IntegrationOffice365RegisterApplication2.jpg
  4. Get the Tenant ID
    1. Hover over the Directory (tenant) ID field and click biExtractSettingsfilesCopyButton3.png.
    2. Back in SysAid, paste the copied text into the Tenant name field.
  5. Get the Client ID
    1. Hover over the Application (client) ID field and click biExtractSettingsfilesCopyButton4.png.
    2. Back in SysAid, paste the copied text into the Client ID field.
  6. Get the Secret Key
    1. From the Left-menu, click Certificates & Secrets.
    2. Click New client secret.
    3. Add a description (e.g. "SysAid Power BI Extract").
    4. In the Expires area, select Never.
    5. Click Add.
    6. In the entry you just created, click biExtractSettingsfilesCopyButton5.png.
    7. Back in SysAid, paste the copied text into the Secret Key field.
  7. In the Email address field, enter the email address for the administrator's MS One-Drive account.
  8. Enter the name you want for the JSON file that will be created with the BI data from SysAid. Make sure the file name includes the extension .json (for example, "SysAidData.json").
  9. Configure API Permissions
    1. In Azure, navigate to select API Permissions.
    2. Click Add a permission.
    3. Click Select an API > Microsoft Graph.
    4. Click Application.
    5. Select the following permissions
      • ReadWrite.All
      • Files.ReadWrite.All
    6. Select the respective type for each permission.
    7. Enable the following permissions:
      biExtractSettingsfilesNewPermissions.png
  10. Click Save Changes.
  11. Click the slider to activate the add-on.
  12. Click Test Connection to ensure that everything has been configured correctly. The results appear at the top of the screen.
  13. (Optional) You can click azureSettingsfilesManual.png to manually import BI Data to the JSON file.
  14. The Last Updated field indicates when the file was last updated.
    biExtractSettingsfilesBIExtractSetup.jpg

Import SysAid data to Power BI

The template is integrated with the field structure for SysAid tickets. It's important that you modify the data source to match the file location where you store this file. You can search for the file in One Drive and use it to display the data in Power BI or other BI tools that you connect to One Drive.

Click here to download a ready-to-go Power BI Template file that you can use to generate dashboards with your SysAid data.

If you encounter any issues with loading this template, ensure that "Application language" in your Power BI Regional Settings is set to English (United States). For any other issues importing your data into Power BI, we recommend referring to the Power BI community.

Map additional SysAid fields to Power BI

The BI Analytics Settings section allows you to map additional fields to be included in your Power BI data extract.

When you map a field to one of the Target BI Fields, that field can be accessed by Power BI Extract. By default, only the List fields are available (as "cust_list 1" and "cust_list 2) in Power BI Extract. To access additional fields, contact your account manager.

Changes made here take affect on new data collected by Power BI Extract from the time you make the changes and onward. To apply new field-mapping on historical data, please contact SysAid Support.

To map a field to Power BI Extract

  1. Locate the field in the Source Field column in the drop-down list corresponding to its field type.
  2. Select the field from the list.
  3. Click Save Changes.
    biExtractSettingsfilesBIAS.png

Was this article helpful?

What's Next