Power BI Chart Buffer

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/6305

Table Type: Company

Table Name: Power BI Chart Buffer
Database Table Name: CRONUS UK Ltd_$Power BI Chart Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 6305

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 Chart Buffer can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Power BI Chart Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[ID]
   ,[Row No_]
   ,[Value]
   ,[Period Type]
   ,[Date]
   ,[Measure Name]
   ,[Date Filter]
   ,[Date Sorting]
   ,[Chart Type]
   ,[Measure No_]
   ,[Period Type Sorting]
   ,[Show Orders]
   ,[Values to Calculate]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Power BI Chart Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Power BI Chart Buffer table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2ID Primary Key Searchint
3Row No_ Searchnvarchar(40)
4Value Searchdecimal(38,38)
5Period Type Searchint
6Date Searchnvarchar(60)
7Measure Name Searchnvarchar(240)
8Date Filter Searchnvarchar(100)
9Date Sorting Searchint
10Chart Type Searchint
11Measure No_ Searchnvarchar(40)
12Period Type Sorting Searchint
13Show Orders Searchnvarchar(100)
14Values to Calculate Searchnvarchar(100)
15$systemId Searchuniqueidentifier
16$systemCreatedAt Searchdatetime
17$systemCreatedBy Searchuniqueidentifier
18$systemModifiedAt Searchdatetime
19$systemModifiedBy Searchuniqueidentifier

Leave a Reply

Your email address will not be published. Required fields are marked *