Report table/entity reference
Note
Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.
Data summary in an easy-to-read layout.
Messages
Message | Web API Operation | SDK class or method |
---|---|---|
Assign | PATCH /reports(reportid) Update ownerid property. |
AssignRequest |
Create | POST /reports See Create |
CreateRequest or Create |
Delete | DELETE /reports(reportid) See Delete |
DeleteRequest or Delete |
DownloadReportDefinition | DownloadReportDefinition | DownloadReportDefinitionRequest |
GetReportHistoryLimit | GetReportHistoryLimit | GetReportHistoryLimitRequest |
GrantAccess | GrantAccess | GrantAccessRequest |
ModifyAccess | ModifyAccess | ModifyAccessRequest |
Retrieve | GET /reports(reportid) See Retrieve |
RetrieveRequest or Retrieve |
RetrieveMultiple | GET /reports See Query Data |
RetrieveMultipleRequest or RetrieveMultiple |
RetrievePrincipalAccess | RetrievePrincipalAccess | RetrievePrincipalAccessRequest |
RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccessRequest |
RevokeAccess | RevokeAccess | RevokeAccessRequest |
SetReportRelated | SetReportRelated | SetReportRelatedRequest |
Update | PATCH /reports(reportid) See Update |
UpdateRequest or Update |
Properties
Property | Value |
---|---|
CollectionSchemaName | Reports |
DisplayCollectionName | Reports |
DisplayName | Report |
EntitySetName | reports |
IsBPFEntity | False |
LogicalCollectionName | reports |
LogicalName | report |
OwnershipType | UserOwned |
PrimaryIdAttribute | reportid |
PrimaryNameAttribute | name |
SchemaName | Report |
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 |
FormatName | TextArea |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | bodybinary |
MaxLength | 1073741823 |
RequiredLevel | None |
Type | String |
BodyText
Property | Value |
---|---|
Description | Text contents of the RDL file for a Reporting Services report. |
DisplayName | Body Text |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | bodytext |
MaxLength | 1073741823 |
RequiredLevel | None |
Type | String |
BodyUrl
Property | Value |
---|---|
Description | URL for a linked report. |
DisplayName | Linked Report URL |
FormatName | Url |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | bodyurl |
MaxLength | 200 |
RequiredLevel | None |
Type | String |
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 |
Format | None |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | createdinmajorversion |
MaxValue | 2147483647 |
MinValue | 0 |
RequiredLevel | None |
Type | Integer |
DefaultFilter
Property | Value |
---|---|
Description | Default filter for the report. |
DisplayName | Default filter |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | defaultfilter |
MaxLength | 1073741823 |
RequiredLevel | None |
Type | String |
DependentModelReportId
Added by: CDS Report Schema Changes Solution
Property | Value |
---|---|
Description | Field to represent the dependent report dataset model. |
DisplayName | Dependent Model Report Id |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | dependentmodelreportid |
RequiredLevel | None |
Targets | report |
Type | Lookup |
Description
Property | Value |
---|---|
Description | Description of the report. |
DisplayName | Description |
FormatName | TextArea |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | description |
MaxLength | 256 |
RequiredLevel | None |
Type | String |
FileName
Property | Value |
---|---|
Description | File name of the report. |
DisplayName | File Name |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | filename |
MaxLength | 255 |
RequiredLevel | None |
Type | String |
IntroducedVersion
Property | Value |
---|---|
Description | Version in which the report is introduced. |
DisplayName | Introduced Version |
FormatName | VersionNumber |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | introducedversion |
MaxLength | 48 |
RequiredLevel | None |
Type | String |
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 |
IsPersonal Choices/Options
Value | Label | Description |
---|---|---|
1 | Individual | |
0 | Organization |
DefaultValue: 1
LanguageCode
Property | Value |
---|---|
Description | Language in which the report will be displayed. |
DisplayName | Language |
Format | Language |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | languagecode |
MaxValue | 2147483647 |
MinValue | 0 |
RequiredLevel | ApplicationRequired |
Type | Integer |
ManagedType
Added by: CDS Report Schema Changes Solution
Property | Value |
---|---|
Description | Determine how the report workspace is managed. |
DisplayName | ManagedType |
IsValidForForm | True |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | managedtype |
RequiredLevel | None |
Type | Picklist |
ManagedType Choices/Options
Value | Label | Description |
---|---|---|
0 | Dataverse | |
1 | Customer |
MimeType
Property | Value |
---|---|
Description | MIME type of the report. |
DisplayName | Mime Type |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | mimetype |
MaxLength | 256 |
RequiredLevel | None |
Type | String |
Name
Property | Value |
---|---|
Description | Name of the report. |
DisplayName | Name |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | name |
MaxLength | 425 |
RequiredLevel | SystemRequired |
Type | String |
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 |
Targets | systemuser,team |
Type | Owner |
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 |
Targets | report |
Type | Lookup |
PowerBiFeatureTag
Added by: CDS Report Schema Changes Solution
Property | Value |
---|---|
Description | Field to maintain the sub application id and feature tag for powerbi reports. |
DisplayName | powerbifeaturetag |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | powerbifeaturetag |
MaxLength | 1024 |
RequiredLevel | None |
Type | String |
ReportId
Property | Value |
---|---|
Description | Unique identifier of the report. |
DisplayName | Report |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | reportid |
RequiredLevel | SystemRequired |
Type | Uniqueidentifier |
ReportStatus
Added by: CDS Report Schema Changes Solution
Property | Value |
---|---|
Description | Represents the status of the Report. |
DisplayName | Report Status |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | reportstatus |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ReportTypeCode
Property | Value |
---|---|
Description | Type of the report. |
DisplayName | Report Type |
IsValidForForm | True |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | reporttypecode |
RequiredLevel | ApplicationRequired |
Type | Picklist |
ReportTypeCode Choices/Options
Value | Label | Description |
---|---|---|
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
Added by: CDS Report Schema Changes Solution
Property | Value |
---|---|
Description | Represents the version of a report. |
DisplayName | Report Version |
Format | None |
IsValidForForm | True |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | reportversion |
MaxValue | 2147483647 |
MinValue | 0 |
RequiredLevel | None |
Type | Integer |
SignatureDate
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Report signature date, used to identify a report for upgrades and hotfixes. |
DisplayName | Report Signature Date |
Format | DateOnly |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | signaturedate |
RequiredLevel | None |
Type | DateTime |
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 |
IsValidForUpdate | False |
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 |
Format | Language |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | signaturelcid |
MaxValue | 2147483647 |
MinValue | 0 |
RequiredLevel | None |
Type | Integer |
SignatureMajorVersion
Property | Value |
---|---|
Description | Report signature major version, used to identify a report for upgrades and hotfixes. |
DisplayName | Report Signature Major Version |
Format | None |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | signaturemajorversion |
MaxValue | 2147483647 |
MinValue | 0 |
RequiredLevel | None |
Type | Integer |
SignatureMinorVersion
Property | Value |
---|---|
Description | Report signature minor version, used to identify a report for upgrades and hotfixes. |
DisplayName | Report Signature Minor Version |
Format | None |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | signatureminorversion |
MaxValue | 2147483647 |
MinValue | 0 |
RequiredLevel | None |
Type | Integer |
TimeZoneRuleVersionNumber
Property | Value |
---|---|
Description | For internal use only. |
DisplayName | Time Zone Rule Version Number |
Format | None |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | timezoneruleversionnumber |
MaxValue | 2147483647 |
MinValue | -1 |
RequiredLevel | None |
Type | Integer |
UTCConversionTimeZoneCode
Property | Value |
---|---|
Description | Time zone code that was in use when the record was created. |
DisplayName | UTC Conversion Time Zone Code |
Format | None |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | utcconversiontimezonecode |
MaxValue | 2147483647 |
MinValue | -1 |
RequiredLevel | None |
Type | Integer |
Read-only columns/attributes
These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.
- ApplicationId
- CdsDatasetId
- ComponentState
- CreatedBy
- CreatedByName
- CreatedByYomiName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- CustomReportXml
- DependentModelReportIdName
- FileContent
- FileContent_Name
- FileSize
- IsCustomReport
- IsManaged
- IsScheduledReport
- ModifiedBy
- ModifiedByName
- ModifiedByYomiName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- OriginalBodyText
- OverwriteTime
- OwnerIdName
- OwnerIdYomiName
- OwningBusinessUnit
- OwningBusinessUnitName
- OwningTeam
- OwningUser
- ParentReportIdName
- PowerBiReportId
- PowerBiReportInternalState
- PowerBiReportName
- PowerBiWorkspaceInfo
- QueryInfo
- RdlHash
- ReportIdUnique
- ReportNameOnSRS
- ScheduleXml
- SolutionId
- SupportingSolutionId
- VersionNumber
ApplicationId
Added by: CDS Report Schema Changes Solution
Property | Value |
---|---|
Description | Represents the application id to which a CDS powerbi report belongs to. |
DisplayName | ApplicationId |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | applicationid |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
CdsDatasetId
Added by: CDS Report Schema Changes Solution
Property | Value |
---|---|
Description | Represents the dataset id of a report. |
DisplayName | cdsdatasetid |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | cdsdatasetid |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ComponentState
Property | Value |
---|---|
Description | For internal use only. |
DisplayName | Component State |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | componentstate |
RequiredLevel | SystemRequired |
Type | Picklist |
ComponentState Choices/Options
Value | Label | Description |
---|---|---|
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 |
Targets | systemuser |
Type | Lookup |
CreatedByName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
CreatedByYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
CreatedOn
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Date and time when the report was created. |
DisplayName | Created On |
Format | DateAndTime |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | createdon |
RequiredLevel | None |
Type | DateTime |
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 |
Targets | systemuser |
Type | Lookup |
CreatedOnBehalfByName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
CreatedOnBehalfByYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
CustomReportXml
Property | Value |
---|---|
Description | XML used to define a custom report. |
DisplayName | Custom Report XML |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | customreportxml |
MaxLength | 1073741823 |
RequiredLevel | None |
Type | String |
DependentModelReportIdName
Added by: CDS Report Schema Changes Solution
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | dependentmodelreportidname |
MaxLength | 425 |
RequiredLevel | None |
Type | String |
FileContent
Added by: CDS Report Schema Changes Solution
Property | Value |
---|---|
Description | |
DisplayName | File Content |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | filecontent |
RequiredLevel | None |
Type | File |
FileContent_Name
Added by: CDS Report Schema Changes Solution
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | filecontent_name |
MaxLength | 200 |
RequiredLevel | None |
Type | String |
FileSize
Property | Value |
---|---|
Description | File size of the report. |
DisplayName | File Size (Bytes) |
Format | None |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | filesize |
MaxValue | 1000000000 |
MinValue | 0 |
RequiredLevel | None |
Type | Integer |
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 |
IsCustomReport Choices/Options
Value | Label | Description |
---|---|---|
1 | True | |
0 | False |
DefaultValue: 0
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 |
IsManaged Choices/Options
Value | Label | Description |
---|---|---|
1 | Managed | |
0 | Unmanaged |
DefaultValue: 0
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 |
IsScheduledReport Choices/Options
Value | Label | Description |
---|---|---|
1 | True | |
0 | False |
DefaultValue: 0
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 |
Targets | systemuser |
Type | Lookup |
ModifiedByName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ModifiedByYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ModifiedOn
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Date and time when the report was last modified. |
DisplayName | Modified On |
Format | DateAndTime |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedon |
RequiredLevel | None |
Type | DateTime |
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 |
Targets | systemuser |
Type | Lookup |
ModifiedOnBehalfByName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ModifiedOnBehalfByYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
OriginalBodyText
Property | Value |
---|---|
Description | Original Text contents of the RDL file for a Reporting Services report. |
DisplayName | Body Text |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | originalbodytext |
MaxLength | 1073741823 |
RequiredLevel | None |
Type | String |
OverwriteTime
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | For internal use only. |
DisplayName | Record Overwrite Time |
Format | DateOnly |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | overwritetime |
RequiredLevel | SystemRequired |
Type | DateTime |
OwnerIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridname |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
OwnerIdYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridyominame |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
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 |
Targets | businessunit |
Type | Lookup |
OwningBusinessUnitName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owningbusinessunitname |
MaxLength | 160 |
RequiredLevel | None |
Type | String |
OwningTeam
Property | Value |
---|---|
Description | Unique identifier of the team who owns the report. |
DisplayName | Owning Team |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owningteam |
RequiredLevel | None |
Targets | team |
Type | Lookup |
OwningUser
Property | Value |
---|---|
Description | Unique identifier of the user who owns the report. |
DisplayName | Owning User |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owninguser |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
ParentReportIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | parentreportidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
PowerBiReportId
Added by: CDS Report Schema Changes Solution
Property | Value |
---|---|
Description | Represents the powerbi report id for a CDS report. |
DisplayName | PowerBiReportId |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | powerbireportid |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
PowerBiReportInternalState
Added by: CDS Report Schema Changes Solution
Property | Value |
---|---|
Description | Field to maintain the internal state of the report |
DisplayName | powerbireportinternalstate |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | powerbireportinternalstate |
MaxLength | 1024 |
RequiredLevel | None |
Type | String |
PowerBiReportName
Added by: CDS Report Schema Changes Solution
Property | Value |
---|---|
Description | Contains the name of the Power Bi embedded report. |
DisplayName | Power Bi Report Name |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | powerbireportname |
MaxLength | 500 |
RequiredLevel | None |
Type | String |
PowerBiWorkspaceInfo
Added by: CDS Report Schema Changes Solution
Property | Value |
---|---|
Description | Contains the workspace information of the Power Bi embedded report. |
DisplayName | Power Bi Workspace Information |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | powerbiworkspaceinfo |
MaxLength | 1024 |
RequiredLevel | None |
Type | String |
QueryInfo
Property | Value |
---|---|
Description | For internal use only. |
DisplayName | Query Info Structure |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | queryinfo |
MaxLength | 1073741823 |
RequiredLevel | None |
Type | String |
RdlHash
Property | Value |
---|---|
Description | Hash value of the body text of the report. |
DisplayName | Body Text Hash |
Format | None |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | rdlhash |
MaxValue | 2147483647 |
MinValue | -2147483648 |
RequiredLevel | None |
Type | Integer |
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 |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | reportnameonsrs |
MaxLength | 425 |
RequiredLevel | None |
Type | String |
ScheduleXml
Property | Value |
---|---|
Description | XML used for defining the report schedule. |
DisplayName | Schedule Definition XML |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | schedulexml |
MaxLength | 1073741823 |
RequiredLevel | None |
Type | String |
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 |
MaxValue | 9223372036854775807 |
MinValue | -9223372036854775808 |
RequiredLevel | None |
Type | BigInt |
One-To-Many Relationships
Listed by SchemaName.
- Report_ProcessSessions
- Report_SyncErrors
- Report_AsyncOperations
- report_reportcategories
- report_parent_report
- Report_Report_DependentModelReportId
Report_ProcessSessions
Same as the Report_ProcessSessions many-to-one relationship for the processsession table/entity.
Property | Value |
---|---|
ReferencingEntity | processsession |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | Report_ProcessSessions |
AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 110 |
CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Report_SyncErrors
Same as the Report_SyncErrors many-to-one relationship for the syncerror table/entity.
Property | Value |
---|---|
ReferencingEntity | syncerror |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | Report_SyncErrors |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade |
Report_AsyncOperations
Same as the Report_AsyncOperations many-to-one relationship for the asyncoperation table/entity.
Property | Value |
---|---|
ReferencingEntity | asyncoperation |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | Report_AsyncOperations |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
report_reportcategories
Same as the report_reportcategories many-to-one relationship for the reportcategory table/entity.
Property | Value |
---|---|
ReferencingEntity | reportcategory |
ReferencingAttribute | reportid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | report_reportcategories |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
report_parent_report
Same as the report_parent_report many-to-one relationship for the report table/entity.
Property | Value |
---|---|
ReferencingEntity | report |
ReferencingAttribute | parentreportid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | report_parent_report |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: RemoveLink Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
Report_Report_DependentModelReportId
Added by: CDS Report Schema Changes Solution
Same as the Report_Report_DependentModelReportId many-to-one relationship for the report table/entity.
Property | Value |
---|---|
ReferencingEntity | report |
ReferencingAttribute | dependentmodelreportid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | Report_Report_DependentModelReportId |
AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 10000 |
CascadeConfiguration | Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Many-To-One Relationships
Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related table. Listed by SchemaName.
- lk_report_createdonbehalfby
- lk_report_modifiedonbehalfby
- report_parent_report
- lk_reportbase_modifiedby
- business_unit_reports
- lk_reportbase_createdby
- Report_Report_DependentModelReportId
lk_report_createdonbehalfby
See the lk_report_createdonbehalfby one-to-many relationship for the systemuser table/entity.
lk_report_modifiedonbehalfby
See the lk_report_modifiedonbehalfby one-to-many relationship for the systemuser table/entity.
report_parent_report
See the report_parent_report one-to-many relationship for the report table/entity.
lk_reportbase_modifiedby
See the lk_reportbase_modifiedby one-to-many relationship for the systemuser table/entity.
business_unit_reports
See the business_unit_reports one-to-many relationship for the businessunit table/entity.
lk_reportbase_createdby
See the lk_reportbase_createdby one-to-many relationship for the systemuser table/entity.
Report_Report_DependentModelReportId
See the Report_Report_DependentModelReportId one-to-many relationship for the report table/entity.
See also
Dataverse table/entity reference
Web API Reference
report EntityType
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for