Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/6312
Table Type: Company
Table Name: Power BI Displayed Element
Database Table Name: CRONUS UK Ltd_$Power BI Displayed Element$437dbf0e-84ff-417a-965d-ed2bb9650972
Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how Power BI Displayed Element can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Power BI Displayed Element$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[UserSID]
,[Context]
,[ElementId]
,[ElementType]
,[ElementName]
,[ElementEmbedUrl]
,[WorkspaceID]
,[WorkspaceName]
,[ReportPage]
,[ShowPanesInNormalMode]
,[ShowPanesInExpandedMode]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Power BI Displayed Element$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$Power BI Displayed Element$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Power BI Displayed Element]
LEFT JOIN
[User] AS [User]
ON
[Power BI Displayed Element].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Power BI Displayed Element].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Power BI Displayed Element table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | UserSID  | User Security ID | Normal | GUID | 16 | UserSID | uniqueidentifier |
| 2 | Context  | Context | Normal | Text | 50 | Context | nvarchar(100) |
| 3 | ElementId | Element ID | Normal | Text | 2048 | ElementId | nvarchar(4096) |
| 4 | ElementType | Element Type | Normal | Option | 4 | ElementType | int |
Available options are:
| |||||||
| 10 | ElementName | Element Name | Normal | Text | 200 | ElementName | nvarchar(400) |
| 11 | ElementEmbedUrl | Element Embed Url | Normal | Text | 2048 | ElementEmbedUrl | nvarchar(4096) |
| 20 | WorkspaceID | Workspace ID | Normal | GUID | 16 | WorkspaceID | uniqueidentifier |
| 21 | WorkspaceName | Workspace Display Name | Normal | Text | 200 | WorkspaceName | nvarchar(400) |
| 50 | ReportPage | Report Page | Normal | Text | 200 | ReportPage | nvarchar(400) |
| 51 | ShowPanesInNormalMode | Show Panes in Normal Mode | Normal | Boolean | 4 | ShowPanesInNormalMode | tinyint |
| 52 | ShowPanesInExpandedMode | Show Panes in Expanded Mode | Normal | Boolean | 4 | ShowPanesInExpandedMode | tinyint |
| 2000000000 | $systemId | System ID | Normal | GUID | 16 | $systemId | uniqueidentifier |
| 2000000001 | SystemCreatedAt | Created At | Normal | DateTime | 8 | $systemCreatedAt | datetime |
| 2000000002 | SystemCreatedBy | Created By | Normal | GUID | 16 | $systemCreatedBy | uniqueidentifier |
Key to join to the User table.Show/hide example querySELECT [Power BI Displayed Element].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Power BI Displayed Element$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Power BI Displayed Element] LEFT JOIN [User] AS [User] ON [Power BI Displayed Element].[$systemCreatedBy] = [User].[User Security ID] | |||||||
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |