Power BI Connector for SharePoint

Build 21.0.8136


Create, update, query, and delete items in SharePoint Issue Tracking lists.


Name Type ReadOnly Description
ID [KEY] String True

The ID of the list entry. The format of the ID is: List|ItemID.

List String False

The name of the issue tracking list.

Title String False

The title of the entry.

AssignedTo String False

The user the issue is assigned to.

Status String False

The status of the issue.

Priority String False

The priority assigned to this issue.

Category String False

The category that the issue belongs to.

DueDate Date False

The due date of the issue.

RelatedIssues String False

A list of related issues.

Comments String False

Comments associated with this issue.

Author String False

The user that created the item.

Editor String False

The last user that modified the item.

Modified Date False

The date modified.

Created Date False

The date created.


SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
CAMLQuery String

The query to be used while listing the list items.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8136