Versions Compared

Version Old Version 3 New Version Current
Changes made by

Melanie Corletto

Amith Mathur

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

When data is extracted using the Power BI Connector, depending on the field being extracted it is contained in a specific table depending on the field being extracted. If the fields are contained included in different tables, it is necessary to establish logical relationships between them so that reports can be created to create reports based on those fields.

Below are some examples that may help to determine which fields should be related depending on the tables.

...

  1. Given the tables “Jira Issues”, “Jira Issue Worklogs”, and “Tempo Accounts”, the fields that should be related are the following:

    1. Issues: Account → Tempo Accounts: Account Name

      Image RemovedImage RemovedImage Added

      Image Added

    2. Issues: Key → Worklogs: Key

      Image RemovedImage Added

  2. Given the tables “Jira Issues” and “Jira Groups” some examples are the following:

    1. Issues: “Creator: AccountId” → Jira Groups: Member Account Id

    2. Issues: ”Current Assignee AccountId” → Jira Groups: “Member Account Id"

For other use cases, it is important to analyze the content of tables and find for similarities on them to make a proper association.

...