Power BI Connector for Microsoft Planner

Build 24.0.8963

PlanDetails

null

Table Specific Information

Select

The connector will use the Microsoft Planner 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.

  • PlanId supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM PlanDetails WHERE planId = 'nETc1IDpYkmb1E17w8TxGmUAGFWC'

INSERT

INSERT is not supported for this table.

Update

Microsoft Planner allows updates for the title, bucketId, percentComplete, assigneePriority, conversationThreadId, orderHint, dueDateTime and startDateTime columns.

UPDATE PlanDetails SET categoryDescriptions_category1 = 'Cat#1', categoryDescriptions_category2 = 'Cat#2', categoryDescriptions_category3 = 'Cat#3', categoryDescriptions_category4 = 'Cat#4', categoryDescriptions_category5 = 'Cat#5', categoryDescriptions_category6 = 'Cat#6'  WHERE PlanId = 'nETc1IDpYkmb1E17w8TxGmUAGFWC'

Delete

Delete is not supported for this table.

Columns

Name Type ReadOnly Description
categoryDescriptions_category1 String False

categoryDescriptions_category10 String False

categoryDescriptions_category11 String False

categoryDescriptions_category12 String False

categoryDescriptions_category13 String False

categoryDescriptions_category14 String False

categoryDescriptions_category15 String False

categoryDescriptions_category16 String False

categoryDescriptions_category17 String False

categoryDescriptions_category18 String False

categoryDescriptions_category19 String False

categoryDescriptions_category2 String False

categoryDescriptions_category20 String False

categoryDescriptions_category21 String False

categoryDescriptions_category22 String False

categoryDescriptions_category23 String False

categoryDescriptions_category24 String False

categoryDescriptions_category25 String False

categoryDescriptions_category3 String False

categoryDescriptions_category4 String False

categoryDescriptions_category5 String False

categoryDescriptions_category6 String False

categoryDescriptions_category7 String False

categoryDescriptions_category8 String False

categoryDescriptions_category9 String False

sharedWith String False

PlanId [KEY] String False

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963