Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Data summary in an easy-to-read layout.
Messages
The following table lists the messages for the Report table. Messages represent operations that can be performed on the table. They may also be events.
| Name Is Event? |
Web API Operation | SDK for .NET |
|---|---|---|
AssignEvent: False |
PATCH /reports(reportid)Update the ownerid property. |
AssignRequest |
AssociateEvent: True |
Associate records | Associate records |
CreateEvent: False |
POST /reportsSee Create |
Create records |
DeleteEvent: False |
DELETE /reports(reportid)See Delete |
Delete records |
DisassociateEvent: True |
Disassociate records | Disassociate records |
DownloadReportDefinitionEvent: False |
DownloadReportDefinition | DownloadReportDefinitionRequest |
GetReportHistoryLimitEvent: False |
GetReportHistoryLimit | GetReportHistoryLimitRequest |
GrantAccessEvent: False |
GrantAccess | GrantAccessRequest |
MakeAvailableToOrganizationReportEvent: False |
MakeAvailableToOrganizationReportRequest | |
MakeAvailableToOrganizationTemplateEvent: False |
MakeAvailableToOrganizationTemplateRequest | |
MakeUnavailableToOrganizationReportEvent: False |
MakeUnavailableToOrganizationReportRequest | |
MakeUnavailableToOrganizationTemplateEvent: False |
MakeUnavailableToOrganizationTemplateRequest | |
ModifyAccessEvent: False |
ModifyAccess | ModifyAccessRequest |
RetrieveEvent: False |
GET /reports(reportid)See Retrieve |
Retrieve records |
RetrieveMultipleEvent: False |
GET /reportsSee Query data |
Query data |
RetrievePrincipalAccessEvent: False |
RetrievePrincipalAccess | RetrievePrincipalAccessRequest |
RetrieveSharedPrincipalsAndAccessEvent: False |
RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccessRequest |
RevokeAccessEvent: False |
RevokeAccess | RevokeAccessRequest |
SetReportRelatedEvent: False |
SetReportRelated | SetReportRelatedRequest |
UpdateEvent: False |
PATCH /reports(reportid)See Update |
Update records |
UpsertEvent: False |
PATCH /reports(reportid)See Upsert a table row |
UpsertRequest |
Properties
The following table lists selected properties for the Report table.
| Property | Value |
|---|---|
| DisplayName | Report |
| DisplayCollectionName | Reports |
| SchemaName | Report |
| CollectionSchemaName | Reports |
| EntitySetName | reports |
| LogicalName | report |
| LogicalCollectionName | reports |
| PrimaryIdAttribute | reportid |
| PrimaryNameAttribute | name |
| TableType | Standard |
| OwnershipType | UserOwned |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- BodyBinary
- BodyText
- BodyUrl
- CreatedInMajorVersion
- DefaultFilter
- DependentModelReportId
- Description
- FileName
- IntroducedVersion
- IsCustomizable
- IsPersonal
- LanguageCode
- ManagedType
- MimeType
- Name
- OwnerId
- OwnerIdType
- ParentReportId
- PowerBiFeatureTag
- ReportId
- ReportStatus
- ReportTypeCode
- ReportVersion
- SignatureDate
- SignatureId
- SignatureLcid
- SignatureMajorVersion
- SignatureMinorVersion
- TimeZoneRuleVersionNumber
- UTCConversionTimeZoneCode
BodyBinary
| Property | Value |
|---|---|
| Description | Binary report contents (base-64 encoded). |
| DisplayName | Body Binary |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | bodybinary |
| RequiredLevel | None |
| Type | String |
| Format | TextArea |
| FormatName | TextArea |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 1073741823 |
BodyText
| Property | Value |
|---|---|
| Description | Text contents of the RDL file for a Reporting Services report. |
| DisplayName | Body Text |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | bodytext |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 1073741823 |
BodyUrl
| Property | Value |
|---|---|
| Description | URL for a linked report. |
| DisplayName | Linked Report URL |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | bodyurl |
| RequiredLevel | None |
| Type | String |
| Format | Url |
| FormatName | Url |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 200 |
CreatedInMajorVersion
| Property | Value |
|---|---|
| Description | Major version number of Crm, used to identify the version of Crm in which report is created. |
| DisplayName | Crm Version in which the Report is created |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdinmajorversion |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | 0 |
DefaultFilter
| Property | Value |
|---|---|
| Description | Default filter for the report. |
| DisplayName | Default filter |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | defaultfilter |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 1073741823 |
DependentModelReportId
| Property | Value |
|---|---|
| Description | Field to represent the dependent report dataset model. |
| DisplayName | Dependent Model Report Id |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | dependentmodelreportid |
| RequiredLevel | None |
| Type | Lookup |
| Targets | report |
Description
| Property | Value |
|---|---|
| Description | Description of the report. |
| DisplayName | Description |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | description |
| RequiredLevel | None |
| Type | String |
| Format | TextArea |
| FormatName | TextArea |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 256 |
FileName
| Property | Value |
|---|---|
| Description | File name of the report. |
| DisplayName | File Name |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | filename |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 255 |
IntroducedVersion
| Property | Value |
|---|---|
| Description | Version in which the report is introduced. |
| DisplayName | Introduced Version |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | introducedversion |
| RequiredLevel | None |
| Type | String |
| Format | VersionNumber |
| FormatName | VersionNumber |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 48 |
IsCustomizable
| Property | Value |
|---|---|
| Description | Information that specifies whether this component can be customized. |
| DisplayName | Customizable |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | iscustomizable |
| RequiredLevel | SystemRequired |
| Type | ManagedProperty |
IsPersonal
| Property | Value |
|---|---|
| Description | Information about whether the report is personal or is available to all users. |
| DisplayName | Viewable By |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | ispersonal |
| RequiredLevel | SystemRequired |
| Type | Boolean |
| GlobalChoiceName | report_ispersonal |
| DefaultValue | True |
| True Label | Individual |
| False Label | Organization |
LanguageCode
| Property | Value |
|---|---|
| Description | Language in which the report will be displayed. |
| DisplayName | Language |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | languagecode |
| RequiredLevel | ApplicationRequired |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | 0 |
ManagedType
| Property | Value |
|---|---|
| Description | Determine how the report workspace is managed. |
| DisplayName | ManagedType |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | managedtype |
| RequiredLevel | None |
| Type | Picklist |
| DefaultFormValue | -1 |
| GlobalChoiceName | reportentity_managedtype |
ManagedType Choices/Options
| Value | Label |
|---|---|
| 0 | Dataverse |
| 1 | Customer |
MimeType
| Property | Value |
|---|---|
| Description | MIME type of the report. |
| DisplayName | Mime Type |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | mimetype |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 256 |
Name
| Property | Value |
|---|---|
| Description | Name of the report. |
| DisplayName | Name |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | name |
| RequiredLevel | SystemRequired |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 425 |
OwnerId
| Property | Value |
|---|---|
| Description | Unique identifier of the user or team who owns the report. |
| DisplayName | Owner |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | ownerid |
| RequiredLevel | SystemRequired |
| Type | Owner |
| Targets | systemuser, team |
OwnerIdType
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridtype |
| RequiredLevel | SystemRequired |
| Type | EntityName |
ParentReportId
| Property | Value |
|---|---|
| Description | Unique identifier of the parent report. |
| DisplayName | Parent Report |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | parentreportid |
| RequiredLevel | None |
| Type | Lookup |
| Targets | report |
PowerBiFeatureTag
| Property | Value |
|---|---|
| Description | Field to maintain the sub application id and feature tag for powerbi reports. |
| DisplayName | powerbifeaturetag |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | powerbifeaturetag |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 1024 |
ReportId
| Property | Value |
|---|---|
| Description | Unique identifier of the report. |
| DisplayName | Report |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | reportid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
ReportStatus
| Property | Value |
|---|---|
| Description | Represents the status of the Report. |
| DisplayName | Report Status |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | reportstatus |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 100 |
ReportTypeCode
| Property | Value |
|---|---|
| Description | Type of the report. |
| DisplayName | Report Type |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | reporttypecode |
| RequiredLevel | ApplicationRequired |
| Type | Picklist |
| DefaultFormValue | -1 |
| GlobalChoiceName | report_reporttypecode |
ReportTypeCode Choices/Options
| Value | Label |
|---|---|
| 1 | Reporting Services Report |
| 2 | Other Report |
| 3 | Linked Report |
| 4 | Power BI Paginated Report |
| 5 | Power BI Analytic Report |
| 6 | Excel Embedded Report |
| 7 | Excel Embedded Report Template |
ReportVersion
| Property | Value |
|---|---|
| Description | Represents the version of a report. |
| DisplayName | Report Version |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | reportversion |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | 0 |
SignatureDate
| Property | Value |
|---|---|
| Description | Report signature date, used to identify a report for upgrades and hotfixes. |
| DisplayName | Report Signature Date |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | signaturedate |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateOnly |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
SignatureId
| Property | Value |
|---|---|
| Description | Unique identifier of the report signature used to identify a report for upgrades and hotfixes. |
| DisplayName | Signature |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | signatureid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
SignatureLcid
| Property | Value |
|---|---|
| Description | Report signature language code used to identify a report for upgrades and hotfixes. |
| DisplayName | Signature Language Code |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | signaturelcid |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | 0 |
SignatureMajorVersion
| Property | Value |
|---|---|
| Description | Report signature major version, used to identify a report for upgrades and hotfixes. |
| DisplayName | Report Signature Major Version |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | signaturemajorversion |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | 0 |
SignatureMinorVersion
| Property | Value |
|---|---|
| Description | Report signature minor version, used to identify a report for upgrades and hotfixes. |
| DisplayName | Report Signature Minor Version |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | signatureminorversion |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | 0 |
TimeZoneRuleVersionNumber
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Time Zone Rule Version Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | timezoneruleversionnumber |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | -1 |
UTCConversionTimeZoneCode
| Property | Value |
|---|---|
| Description | Time zone code that was in use when the record was created. |
| DisplayName | UTC Conversion Time Zone Code |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | utcconversiontimezonecode |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | -1 |
Read-only columns/attributes
These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.
- ApplicationId
- CdsDatasetId
- ComponentState
- CreatedBy
- CreatedOn
- CreatedOnBehalfBy
- CustomReportXml
- FileContent
- FileContent_Name
- FileSize
- IsCustomReport
- IsManaged
- IsScheduledReport
- ModifiedBy
- ModifiedOn
- ModifiedOnBehalfBy
- OriginalBodyText
- OverwriteTime
- OwnerIdName
- OwnerIdYomiName
- OwningBusinessUnit
- OwningTeam
- OwningUser
- PowerBiDatasetId
- PowerBiReportId
- PowerBiReportInternalState
- PowerBiReportName
- PowerBiWorkspaceInfo
- QueryInfo
- RdlHash
- ReportIdUnique
- ReportNameOnSRS
- ScheduleXml
- SolutionId
- SupportingSolutionId
- VersionNumber
ApplicationId
| Property | Value |
|---|---|
| Description | Represents the application id to which a CDS powerbi report belongs to. |
| DisplayName | ApplicationId |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | applicationid |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 100 |
CdsDatasetId
| Property | Value |
|---|---|
| Description | Represents the dataset id of a report. |
| DisplayName | cdsdatasetid |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | cdsdatasetid |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 100 |
ComponentState
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Component State |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | componentstate |
| RequiredLevel | SystemRequired |
| Type | Picklist |
| DefaultFormValue | -1 |
| GlobalChoiceName | componentstate |
ComponentState Choices/Options
| Value | Label |
|---|---|
| 0 | Published |
| 1 | Unpublished |
| 2 | Deleted |
| 3 | Deleted Unpublished |
CreatedBy
| Property | Value |
|---|---|
| Description | Unique identifier of the user who created the report. |
| DisplayName | Created By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdby |
| RequiredLevel | None |
| Type | Lookup |
| Targets | systemuser |
CreatedOn
| Property | Value |
|---|---|
| Description | Date and time when the report was created. |
| DisplayName | Created On |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdon |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateAndTime |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
CreatedOnBehalfBy
| Property | Value |
|---|---|
| Description | Unique identifier of the delegate user who created the report. |
| DisplayName | Created By (Delegate) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdonbehalfby |
| RequiredLevel | None |
| Type | Lookup |
| Targets | systemuser |
CustomReportXml
| Property | Value |
|---|---|
| Description | XML used to define a custom report. |
| DisplayName | Custom Report XML |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | customreportxml |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 1073741823 |
FileContent
| Property | Value |
|---|---|
| Description | |
| DisplayName | File Content |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | filecontent |
| RequiredLevel | None |
| Type | File |
| MaxSizeInKB | 10485760 |
FileContent_Name
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | filecontent_name |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Disabled |
| IsLocalizable | False |
| MaxLength | 200 |
FileSize
| Property | Value |
|---|---|
| Description | File size of the report. |
| DisplayName | File Size (Bytes) |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | filesize |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 1000000000 |
| MinValue | 0 |
IsCustomReport
| Property | Value |
|---|---|
| Description | Information about whether the report is a custom report. |
| DisplayName | Is Custom Report |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | iscustomreport |
| RequiredLevel | SystemRequired |
| Type | Boolean |
| GlobalChoiceName | report_iscustomreport |
| DefaultValue | False |
| True Label | True |
| False Label | False |
IsManaged
| Property | Value |
|---|---|
| Description | Indicates whether the solution component is part of a managed solution. |
| DisplayName | Is Managed |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | ismanaged |
| RequiredLevel | SystemRequired |
| Type | Boolean |
| GlobalChoiceName | ismanaged |
| DefaultValue | False |
| True Label | Managed |
| False Label | Unmanaged |
IsScheduledReport
| Property | Value |
|---|---|
| Description | Information about whether the report is a scheduled report. |
| DisplayName | Is Scheduled Report |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | isscheduledreport |
| RequiredLevel | SystemRequired |
| Type | Boolean |
| GlobalChoiceName | report_isscheduledreport |
| DefaultValue | False |
| True Label | True |
| False Label | False |
ModifiedBy
| Property | Value |
|---|---|
| Description | Unique identifier of the user who last modified the report. |
| DisplayName | Modified By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedby |
| RequiredLevel | None |
| Type | Lookup |
| Targets | systemuser |
ModifiedOn
| Property | Value |
|---|---|
| Description | Date and time when the report was last modified. |
| DisplayName | Modified On |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedon |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateAndTime |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
ModifiedOnBehalfBy
| Property | Value |
|---|---|
| Description | Unique identifier of the delegate user who last modified the report. |
| DisplayName | Modified By (Delegate) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfby |
| RequiredLevel | None |
| Type | Lookup |
| Targets | systemuser |
OriginalBodyText
| Property | Value |
|---|---|
| Description | Original Text contents of the RDL file for a Reporting Services report. |
| DisplayName | Body Text |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | originalbodytext |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 1073741823 |
OverwriteTime
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Record Overwrite Time |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | overwritetime |
| RequiredLevel | SystemRequired |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateOnly |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
OwnerIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridname |
| RequiredLevel | SystemRequired |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 100 |
OwnerIdYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridyominame |
| RequiredLevel | SystemRequired |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 100 |
OwningBusinessUnit
| Property | Value |
|---|---|
| Description | Unique identifier of the business unit that owns the report. |
| DisplayName | Owning Business Unit |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | owningbusinessunit |
| RequiredLevel | None |
| Type | Lookup |
| Targets | businessunit |
OwningTeam
| Property | Value |
|---|---|
| Description | Unique identifier of the team who owns the report. |
| DisplayName | Owning Team |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owningteam |
| RequiredLevel | None |
| Type | Lookup |
| Targets | team |
OwningUser
| Property | Value |
|---|---|
| Description | Unique identifier of the user who owns the report. |
| DisplayName | Owning User |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owninguser |
| RequiredLevel | None |
| Type | Lookup |
| Targets | systemuser |
PowerBiDatasetId
| Property | Value |
|---|---|
| Description | Represents the Power BI dataset id of a report. |
| DisplayName | PowerBI Dataset Id |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | powerbidatasetid |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 100 |
PowerBiReportId
| Property | Value |
|---|---|
| Description | Represents the powerbi report id for a CDS report. |
| DisplayName | PowerBiReportId |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | powerbireportid |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 100 |
PowerBiReportInternalState
| Property | Value |
|---|---|
| Description | Field to maintain the internal state of the report |
| DisplayName | powerbireportinternalstate |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | powerbireportinternalstate |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 1024 |
PowerBiReportName
| Property | Value |
|---|---|
| Description | Contains the name of the Power Bi embedded report. |
| DisplayName | Power Bi Report Name |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | powerbireportname |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 500 |
PowerBiWorkspaceInfo
| Property | Value |
|---|---|
| Description | Contains the workspace information of the Power Bi embedded report. |
| DisplayName | Power Bi Workspace Information |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | powerbiworkspaceinfo |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 1024 |
QueryInfo
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Query Info Structure |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | queryinfo |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 1073741823 |
RdlHash
| Property | Value |
|---|---|
| Description | Hash value of the body text of the report. |
| DisplayName | Body Text Hash |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | rdlhash |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | -2147483648 |
ReportIdUnique
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Report |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | reportidunique |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
ReportNameOnSRS
| Property | Value |
|---|---|
| Description | Name of the report on SRS. |
| DisplayName | Name on SRS |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | reportnameonsrs |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 425 |
ScheduleXml
| Property | Value |
|---|---|
| Description | XML used for defining the report schedule. |
| DisplayName | Schedule Definition XML |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | schedulexml |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 1073741823 |
SolutionId
| Property | Value |
|---|---|
| Description | Unique identifier of the associated solution. |
| DisplayName | Solution |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | solutionid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
SupportingSolutionId
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Solution |
| IsValidForForm | False |
| IsValidForRead | False |
| LogicalName | supportingsolutionid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
VersionNumber
| Property | Value |
|---|---|
| Description | Version number of the report. |
| DisplayName | Version Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | versionnumber |
| RequiredLevel | None |
| Type | BigInt |
| MaxValue | 9223372036854775807 |
| MinValue | -9223372036854775808 |
Many-to-One relationships
These relationships are many-to-one. Listed by SchemaName.
- business_unit_reports
- FileAttachment_Report_FileContent
- lk_report_createdonbehalfby
- lk_report_modifiedonbehalfby
- lk_reportbase_createdby
- lk_reportbase_modifiedby
- owner_reports
- report_parent_report
- Report_Report_DependentModelReportId
business_unit_reports
One-To-Many Relationship: businessunit business_unit_reports
| Property | Value |
|---|---|
| ReferencedEntity | businessunit |
| ReferencedAttribute | businessunitid |
| ReferencingAttribute | owningbusinessunit |
| ReferencingEntityNavigationPropertyName | owningbusinessunit |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
FileAttachment_Report_FileContent
One-To-Many Relationship: fileattachment FileAttachment_Report_FileContent
| Property | Value |
|---|---|
| ReferencedEntity | fileattachment |
| ReferencedAttribute | fileattachmentid |
| ReferencingAttribute | filecontent |
| ReferencingEntityNavigationPropertyName | filecontent |
| IsHierarchical | |
| CascadeConfiguration | Archive: RemoveLinkAssign: NoCascadeDelete: RemoveLinkMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
lk_report_createdonbehalfby
One-To-Many Relationship: systemuser lk_report_createdonbehalfby
| Property | Value |
|---|---|
| ReferencedEntity | systemuser |
| ReferencedAttribute | systemuserid |
| ReferencingAttribute | createdonbehalfby |
| ReferencingEntityNavigationPropertyName | createdonbehalfby |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
lk_report_modifiedonbehalfby
One-To-Many Relationship: systemuser lk_report_modifiedonbehalfby
| Property | Value |
|---|---|
| ReferencedEntity | systemuser |
| ReferencedAttribute | systemuserid |
| ReferencingAttribute | modifiedonbehalfby |
| ReferencingEntityNavigationPropertyName | modifiedonbehalfby |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
lk_reportbase_createdby
One-To-Many Relationship: systemuser lk_reportbase_createdby
| Property | Value |
|---|---|
| ReferencedEntity | systemuser |
| ReferencedAttribute | systemuserid |
| ReferencingAttribute | createdby |
| ReferencingEntityNavigationPropertyName | createdby |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
lk_reportbase_modifiedby
One-To-Many Relationship: systemuser lk_reportbase_modifiedby
| Property | Value |
|---|---|
| ReferencedEntity | systemuser |
| ReferencedAttribute | systemuserid |
| ReferencingAttribute | modifiedby |
| ReferencingEntityNavigationPropertyName | modifiedby |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
owner_reports
One-To-Many Relationship: owner owner_reports
| Property | Value |
|---|---|
| ReferencedEntity | owner |
| ReferencedAttribute | ownerid |
| ReferencingAttribute | ownerid |
| ReferencingEntityNavigationPropertyName | ownerid |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RestrictMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
report_parent_report
One-To-Many Relationship: report report_parent_report
| Property | Value |
|---|---|
| ReferencedEntity | report |
| ReferencedAttribute | reportid |
| ReferencingAttribute | parentreportid |
| ReferencingEntityNavigationPropertyName | parentreportid |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: CascadeDelete: RemoveLinkMerge: NoCascadeReparent: CascadeRollupView: NoCascadeShare: CascadeUnshare: Cascade |
Report_Report_DependentModelReportId
One-To-Many Relationship: report Report_Report_DependentModelReportId
| Property | Value |
|---|---|
| ReferencedEntity | report |
| ReferencedAttribute | reportid |
| ReferencingAttribute | dependentmodelreportid |
| ReferencingEntityNavigationPropertyName | DependentModelReportId |
| IsHierarchical | |
| CascadeConfiguration | Archive: RemoveLinkAssign: NoCascadeDelete: RemoveLinkMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
One-to-Many relationships
These relationships are one-to-many. Listed by SchemaName.
- Report_AsyncOperations
- report_FileAttachments
- report_parent_report
- Report_ProcessSessions
- Report_Report_DependentModelReportId
- report_reportcategories
- Report_ReportParameter_ReportId
- Report_SyncErrors
Report_AsyncOperations
Many-To-One Relationship: asyncoperation Report_AsyncOperations
| Property | Value |
|---|---|
| ReferencingEntity | asyncoperation |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | Report_AsyncOperations |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
report_FileAttachments
Many-To-One Relationship: fileattachment report_FileAttachments
| Property | Value |
|---|---|
| ReferencingEntity | fileattachment |
| ReferencingAttribute | objectid |
| ReferencedEntityNavigationPropertyName | report_FileAttachments |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
report_parent_report
Many-To-One Relationship: report report_parent_report
| Property | Value |
|---|---|
| ReferencingEntity | report |
| ReferencingAttribute | parentreportid |
| ReferencedEntityNavigationPropertyName | report_parent_report |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Report_ProcessSessions
Many-To-One Relationship: processsession Report_ProcessSessions
| Property | Value |
|---|---|
| ReferencingEntity | processsession |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | Report_ProcessSessions |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionNameGroup: DetailsLabel: MenuId: null Order: 110 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Report_Report_DependentModelReportId
Many-To-One Relationship: report Report_Report_DependentModelReportId
| Property | Value |
|---|---|
| ReferencingEntity | report |
| ReferencingAttribute | dependentmodelreportid |
| ReferencedEntityNavigationPropertyName | Report_Report_DependentModelReportId |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionNameGroup: DetailsLabel: MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
report_reportcategories
Many-To-One Relationship: reportcategory report_reportcategories
| Property | Value |
|---|---|
| ReferencingEntity | reportcategory |
| ReferencingAttribute | reportid |
| ReferencedEntityNavigationPropertyName | report_reportcategories |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Report_ReportParameter_ReportId
Many-To-One Relationship: reportparameter Report_ReportParameter_ReportId
| Property | Value |
|---|---|
| ReferencingEntity | reportparameter |
| ReferencingAttribute | reportid |
| ReferencedEntityNavigationPropertyName | Report_ReportParameters |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionNameGroup: DetailsLabel: Represents collection of ReportParameters belonging to a Report. MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Report_SyncErrors
Many-To-One Relationship: syncerror Report_SyncErrors
| Property | Value |
|---|---|
| ReferencingEntity | syncerror |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | Report_SyncErrors |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
See also
Dataverse table/entity reference
Dataverse Web API Reference
report