Power BI Connector for Microsoft Planner

Build 24.0.8963

Users

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.

  • Id supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM Users WHERE Id = '9523f1-aa0-4fe17-a9w7b-6860618adf'

Columns

Name Type Description
aboutMe String
accountEnabled Bool
ageGroup String
assignedLicenses String
assignedPlans String
authorizationInfo_certificateUserIds String
birthday Datetime
businessPhones String
city String
companyName String
consentProvidedForMinor String
country String
createdDateTime Datetime
creationType String
customSecurityAttributes String
department String
deviceEnrollmentLimit Int
displayName String
employeeHireDate Datetime
employeeId String
employeeLeaveDateTime Datetime
employeeOrgData_costCenter String
employeeOrgData_division String
employeeType String
externalUserState String
externalUserStateChangeDateTime Datetime
faxNumber String
givenName String
hireDate Datetime
identities String
imAddresses String
interests String
isResourceAccount Bool
jobTitle String
lastPasswordChangeDateTime Datetime
legalAgeGroupClassification String
licenseAssignmentStates String
mail String
mailboxSettings_archiveFolder String
mailboxSettings_automaticRepliesSetting_externalAudience String
mailboxSettings_automaticRepliesSetting_externalReplyMessage String
mailboxSettings_automaticRepliesSetting_internalReplyMessage String
mailboxSettings_automaticRepliesSetting_scheduledEndDateTime_dateTime String
mailboxSettings_automaticRepliesSetting_scheduledEndDateTime_timeZone String
mailboxSettings_automaticRepliesSetting_status String
mailboxSettings_dateFormat String
mailboxSettings_delegateMeetingMessageDeliveryOptions String
mailboxSettings_language_displayName String
mailboxSettings_language_locale String
mailboxSettings_timeFormat String
mailboxSettings_timeZone String
mailboxSettings_userPurpose String
mailboxSettings_workingHours_daysOfWeek String
mailboxSettings_workingHours_endTime Time
mailboxSettings_workingHours_startTime Time
mailboxSettings_workingHours_timeZone_name String
mailNickname String
mobilePhone String
mySite String
officeLocation String
onPremisesDistinguishedName String
onPremisesDomainName String
onPremisesExtensionAttributes_extensionAttribute1 String
onPremisesExtensionAttributes_extensionAttribute10 String
onPremisesExtensionAttributes_extensionAttribute11 String
onPremisesExtensionAttributes_extensionAttribute12 String
onPremisesExtensionAttributes_extensionAttribute13 String
onPremisesExtensionAttributes_extensionAttribute14 String
onPremisesExtensionAttributes_extensionAttribute15 String
onPremisesExtensionAttributes_extensionAttribute2 String
onPremisesExtensionAttributes_extensionAttribute3 String
onPremisesExtensionAttributes_extensionAttribute4 String
onPremisesExtensionAttributes_extensionAttribute5 String
onPremisesExtensionAttributes_extensionAttribute6 String
onPremisesExtensionAttributes_extensionAttribute7 String
onPremisesExtensionAttributes_extensionAttribute8 String
onPremisesExtensionAttributes_extensionAttribute9 String
onPremisesImmutableId String
onPremisesLastSyncDateTime Datetime
onPremisesProvisioningErrors String
onPremisesSamAccountName String
onPremisesSecurityIdentifier String
onPremisesSyncEnabled Bool
onPremisesUserPrincipalName String
otherMails String
passwordPolicies String
passwordProfile_forceChangePasswordNextSignIn Bool
passwordProfile_forceChangePasswordNextSignInWithMfa Bool
passwordProfile_password String
pastProjects String
postalCode String
preferredDataLocation String
preferredLanguage String
preferredName String
provisionedPlans String
proxyAddresses String
responsibilities String
schools String
securityIdentifier String
serviceProvisioningErrors String
showInAddressList Bool
signInActivity_lastNonInteractiveSignInDateTime Datetime
signInActivity_lastNonInteractiveSignInRequestId String
signInActivity_lastSignInDateTime Datetime
signInActivity_lastSignInRequestId String
signInSessionsValidFromDateTime Datetime
skills String
state String
streetAddress String
surname String
usageLocation String
userPrincipalName String
userType String
authentication_id String
calendar_id String
cloudClipboard_id String
drive_id String
employeeExperience_id String
inferenceClassification_id String
insights_id String
manager_id String
onenote_id String
outlook_id String
photo_id String
planner_id String
presence_id String
settings_id String
teamwork_id String
todo_id String
UserId [KEY] String

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