PyTable
Bases: PyObject
The main PyTable class to interact with the tables in model.
Attributes:
Name | Type | Description |
---|---|---|
Name |
str
|
Name of table. |
IsHidden |
bool
|
Is the table hidden. |
Description |
str
|
The description of the table. |
Model |
Tabular
|
The parent |
Partitions |
PyPartitions
|
The |
Columns |
PyColumns
|
The |
Measures |
PyMeasures
|
The |
Example
- This shows the ability to travel through your model
to a specific partition and then running a refresh
for that specific partition.
model
->PyTables
->PyTable
(1st index) ->PyPartitions
->PyPartition
(.Name == 'Last Year') ->.refresh()
Source code in pytabular/table.py
18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 |
|
__init__(object, model)
Init extends from PyObject
class.
Also adds a few specific rows to the rich
table.
Parameters:
Name | Type | Description | Default |
---|---|---|---|
object |
Table
|
The actual .Net table. |
required |
model |
Tabular
|
The model that the table is in. |
required |
Source code in pytabular/table.py
row_count()
Method to return count of rows.
Simple Dax Query: EVALUATE {COUNTROWS('Table Name')}
.
Returns:
Name | Type | Description |
---|---|---|
int |
int
|
Number of rows using |
Source code in pytabular/table.py
refresh(*args, **kwargs)
Use this to refresh the PyTable.
Returns:
Type | Description |
---|---|
DataFrame
|
pd.DataFrame: Returns pandas dataframe with some refresh details. |
Example
- You can pass through arguments to
PyRefresh
, like removing trace.
Source code in pytabular/table.py
last_refresh()
Will query each partition for the last refresh time.
Then will select the max value to return.
Returns:
Name | Type | Description |
---|---|---|
datetime |
datetime
|
Last refresh time in datetime format |