Power BI Connector for Salesforce

Build 26.0.9770

IdentityVerificationEvent

Represents an identity verification event, such as a multi-factor authentication challenge.

Columns

Name Type References Description
Id String Unique identifier for the record.
CreatedDate Datetime Date and time when the record was created.
EventIdentifier String Unique identifier for the event.
UserId String

User.Id

ID of the User associated with this record.
Username String Username of the user associated with this record.
EventDate Datetime Date and time when the event occurred.
SessionKey String Unique key identifying the user session.
LoginKey String Unique key identifying the login session.
SessionLevel String Security level of the user session.
SourceIp String IP address from which the request originated.
LoginHistoryId String

LoginHistory.Id

ID of the related login history record.
VerificationMethod String Field containing VerificationMethod information.
Activity String Field containing Activity information.
Status String Status of the record.
Remarks String Field containing Remarks information.
ResourceId String

ConnectedApplication.Id

ID of the Resource associated with this record.
Policy String Field containing Policy information.
EventGroup String Field containing EventGroup information.
CountryIso String Field containing CountryIso information.
Country String Country portion of the address.
Latitude Double Used with Longitude to specify the precise geolocation of an address.
Longitude Double Used with Latitude to specify the precise geolocation of an address.
City String City portion of the address.
PostalCode String Postal code portion of the address.
Subdivision String Field containing Subdivision information.
ProfileId String

Profile.Id

ID of the profile associated with this record.
RoleId String

UserRole.Id

ID of the role associated with this record.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

Name Type Description
UserIdType String Specifies the type of the 'UserId' polymorphic field to use in the statement.
UserIdExternalFieldName String Specifies the external field name of the 'UserId' polymorphic field to use in an INSERT/UPDATE/UPSERT statement
SOQL String Specifies the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precedence over the original query.
ExternalIdColumn String Specifies the external Id column to use if performing an insert. If this value is specified, upsert will be used when the INSERT command is called.
FilterScope String Optional scope to limit the records returned from queries. This property can take one of these values: Delegated, Everything, Mine, MineAndMyGroups, My_Territory, My_Team_Territory, or Team.

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