Power BI Connector for Linear

Build 26.0.9776

Issue

All issues. Returns a paginated list of issues visible to the authenticated user. Can be filtered by various criteria including team, assignee, state, labels, project, and cycle.

Table-Specific Information

SELECT

The connector uses the Linear API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the connector.

ColumnSupported Operators
id=, !=, IN, NOT IN
createdAt=, !=, IN, NOT IN, <, <=, >, >=
updatedAt=, !=, IN, NOT IN, <, <=, >, >=
archivedAt=, !=, IN, NOT IN, IS, IS NOT, <, <=, >, >=
number=, !=, IN, NOT IN, <, <=, >, >=
title=, !=, IN, NOT IN, LIKE, CONTAINS
priority=, !=, IN, NOT IN, IS, IS NOT, <, <=, >, >=
estimate=, !=, IN, NOT IN, IS, IS NOT, <, <=, >, >=
startedAt=, !=, IN, NOT IN, IS, IS NOT, <, <=, >, >=
completedAt=, !=, IN, NOT IN, IS, IS NOT, <, <=, >, >=
triagedAt=, !=, IN, NOT IN, IS, IS NOT, <, <=, >, >=
canceledAt=, !=, IN, NOT IN, IS, IS NOT, <, <=, >, >=
autoClosedAt=, !=, IN, NOT IN, IS, IS NOT, <, <=, >, >=
autoArchivedAt=, !=, IN, NOT IN, IS, IS NOT, <, <=, >, >=
dueDate=, !=, IN, NOT IN, IS, IS NOT, <, <=, >, >=
slaBreachesAt=, !=, IN, NOT IN, IS, IS NOT, <, <=, >, >=
addedToCycleAt=, !=, IN, NOT IN, IS, IS NOT, <, <=, >, >=
snoozedUntilAt=, !=, IN, NOT IN, IS, IS NOT, <, <=, >, >=
teamId=, !=, IN, NOT IN
cycleId=, !=, IN, NOT IN, IS, IS NOT
projectId=, !=, IN, NOT IN, IS, IS NOT
projectMilestoneId=, !=, IN, NOT IN, IS, IS NOT
creatorId=, !=, IN, NOT IN, IS, IS NOT
assigneeId=, !=, IN, NOT IN, IS, IS NOT
delegateId=, !=, IN, NOT IN, IS, IS NOT
snoozedById=, !=, IN, NOT IN, IS, IS NOT
stateId=, !=, IN, NOT IN
parentId=, !=, IN, NOT IN, IS, IS NOT
description=, !=, IN, NOT IN, IS, IS NOT, LIKE, CONTAINS

For example, the following queries are processed server-side: 

SELECT * FROM Issue LIMIT 1
SELECT * FROM Issue WHERE number = 1 LIMIT 1

INSERT

To insert an Issue record: 
INSERT INTO Issue (teamId, createdAt, title) VALUES ('921cb6bf-d5b6-44bb-9c6b-217b97dd27a2', '2026-01-01T00:00:00Z', 'sample')

UPDATE

To update an Issue record: 
UPDATE Issue SET title = 'sample' WHERE id = '6b0685fc-9057-4401-92d5-80bf69df275f'

DELETE

To delete an Issue record: 
DELETE FROM Issue WHERE id = '6b0685fc-9057-4401-92d5-80bf69df275f'

Columns

Name Type ReadOnly Description
id [KEY] String False

The unique identifier of the entity.

createdAt Datetime False

The time at which the entity was created.

updatedAt Datetime True

The last time at which the entity was meaningfully updated. This is the same as the creation time if the entity hasn't been updated after creation.

archivedAt Datetime True

The time at which the entity was archived. Null if the entity has not been archived.

number Double True

The issue's unique number, scoped to the issue's team. Together with the team key, this forms the issue's human-readable identifier (e.g., ENG-123).

title String False

The issue's title. This is the primary human-readable summary of the work item.

priority Double False

The priority of the issue. 0 = No priority, 1 = Urgent, 2 = High, 3 = Medium, 4 = Low.

estimate Double False

The estimate of the complexity of the issue. The specific scale used depends on the team's estimation configuration (e.g., points, T-shirt sizes). Null if no estimate has been set.

sortOrder Double False

The order of the item in relation to other items in the organization. Used for manual sorting in list views.

prioritySortOrder Double False

The order of the item in relation to other items in the workspace, when ordered by priority.

startedAt Datetime True

The time at which the issue was moved into started state.

completedAt Datetime False

The time at which the issue was moved into completed state.

startedTriageAt Datetime True

The time at which the issue entered triage.

triagedAt Datetime True

The time at which the issue left triage.

canceledAt Datetime True

The time at which the issue was moved into canceled state.

autoClosedAt Datetime True

The time at which the issue was automatically closed by the auto pruning process.

autoArchivedAt Datetime True

The time at which the issue was automatically archived by the auto pruning process.

dueDate Date False

The date at which the issue is due.

slaStartedAt Datetime False

The time at which the issue's SLA began.

slaMediumRiskAt Datetime True

The time at which the issue's SLA will enter medium risk state.

slaHighRiskAt Datetime True

The time at which the issue's SLA will enter high risk state.

slaBreachesAt Datetime False

The time at which the issue's SLA will breach.

slaType String False

The type of SLA set on the issue. Calendar days or business days.

addedToProjectAt Datetime True

The time at which the issue was added to a project.

addedToCycleAt Datetime True

The time at which the issue was added to a cycle.

addedToTeamAt Datetime True

The time at which the issue was added to a team.

trashed Bool False

A flag that indicates whether the issue is in the trash bin.

snoozedUntilAt Datetime False

The time until an issue will be snoozed in Triage view.

suggestionsGeneratedAt Datetime True

[Internal] The time at which the most recent suggestions for this issue were generated.

activitySummary String True

[Internal] The activity summary information for this issue.

labelIds String False

Identifiers of the labels associated with this issue. Can be used to query the labels directly. Returned as a JSON array of String values; accepts a JSON array or a comma-separated list when written.

teamId String False

The team that the issue belongs to. Every issue must belong to exactly one team, which determines the available workflow states, labels, and other team-specific configuration.

cycleId String False

The cycle that the issue is associated with. Null if the issue is not part of any cycle.

projectId String False

The project that the issue is associated with. Null if the issue is not part of any project.

projectMilestoneId String False

The project milestone that the issue is associated with. Null if the issue is not assigned to a specific milestone within its project.

previousIdentifiers String True

Previous identifiers of the issue if it has been moved between teams. Returned as a JSON array of String values; accepts a JSON array or a comma-separated list when written.

creatorId String True

The user who created the issue. Null if the creator's account has been deleted or if the issue was created by an integration or system process.

externalUserCreatorId String True

The external user who created the issue. Set when the issue was created via an integration (e.g., Slack, Intercom) on behalf of a non-Linear user. Null if the issue was created by a Linear user.

assigneeId String False

The user to whom the issue is assigned. Null if the issue is unassigned.

delegateId String False

The agent user that is delegated to work on this issue. Set when an AI agent has been assigned to perform work on this issue. Null if no agent is working on the issue.

snoozedById String False

The user who snoozed the issue.

stateId String False

The workflow state (issue status) that the issue is currently in. Workflow states represent the issue's progress through the team's workflow, such as Triage, Todo, In Progress, Done, or Canceled.

subIssueSortOrder Double False

The order of the item in the sub-issue list. Only set if the issue has a parent.

reactionData String True

Emoji reaction summary for the issue, grouped by emoji type. Contains the count and reacting user information for each emoji.

priorityLabel String True

Label for the priority.

sourceCommentId String False

The comment that this issue was created from, when an issue is created from an existing comment. Null if the issue was not created from a comment.

trusted Bool False

[Internal] Whether this issue has been explicitly marked as trusted.

integrationSourceType String True

Integration type that created this issue, if applicable.

inheritsSharedAccess Bool False

Whether this issue inherits shared access from its parent issue.

favoriteId String True

The users favorite associated with this issue.

identifier String True

Issue's human readable identifier (e.g. ENG-123).

url String True

Issue URL.

branchName String True

Suggested branch name for the issue.

customerTicketCount Int True

Returns the number of Attachment resources which are created by customer support ticketing systems (e.g. Zendesk).

parentId String False

The parent of the issue.

description String False

The issue's description in markdown format.

descriptionState String True

[Internal] The issue's description content as YJS state.

asksRequesterId String True

The internal user who requested creation of the Asks issue on behalf of the creator.

asksExternalUserRequesterId String True

The external user who requested creation of the Asks issue on behalf of the creator.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9776