Get Table Rows
Name
get_table_rows
Description
Related Tables
Parameters
Parameter | Label | Required | Options | Description | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
TableName | TableName | YES | ||||||||||||||
DatasetId | DatasetId | NO | ||||||||||||||
WorkspaceId | WorkspaceId | NO |
|
|||||||||||||
DaxFilter | DaxFilter | NO |
|
[API reference] |
Output Columns
Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description |
---|---|---|---|---|---|
[$parent.Column Name$] |
DT_WSTR
|
nvarchar(4000)
|
4000 | False |
Input Columns
Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime. |
Examples
SSIS
Use Power BI Connector in API Source component to read data or in API Destination component to read/write data:
Read from [Dynamic Table] table using API Destination
This Endpoint belongs to [Dynamic Table] table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

ODBC application
Use these SQL queries in your ODBC application data source:
Tables - Get Table Rows for a specified Workspace and Dataset
SELECT *
FROM get_table_rows
WITH(
"TableName"='Products'
, "DatasetId"='11b6c287-51d3-4061-bed8-811a4e5f6ce9'
, "WorkspaceId"='848353e2-f3b1-4fb4-89d7-44e84b8bdf9f'
)
Tables - Get Table rows
SELECT *
FROM get_table_rows
WITH (TableName='MyTable')
Tables - Get Table rows in a specified Dataset
SELECT *
FROM get_table_rows
WITH (TableName='MyTable', DatasetId='aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee')
get_table_rows
endpoint belongs to
[Dynamic Table]
table(s), and can therefore be used via those table(s).
SQL Server
Use these SQL queries in SQL Server after you create a data source in Data Gateway:
Tables - Get Table Rows for a specified Workspace and Dataset
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT *
FROM get_table_rows
WITH(
"TableName"=''Products''
, "DatasetId"=''11b6c287-51d3-4061-bed8-811a4e5f6ce9''
, "WorkspaceId"=''848353e2-f3b1-4fb4-89d7-44e84b8bdf9f''
)';
EXEC (@MyQuery) AT [LS_TO_POWER_BI_IN_GATEWAY];
Tables - Get Table rows
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT *
FROM get_table_rows
WITH (TableName=''MyTable'')';
EXEC (@MyQuery) AT [LS_TO_POWER_BI_IN_GATEWAY];
Tables - Get Table rows in a specified Dataset
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT *
FROM get_table_rows
WITH (TableName=''MyTable'', DatasetId=''aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee'')';
EXEC (@MyQuery) AT [LS_TO_POWER_BI_IN_GATEWAY];
get_table_rows
endpoint belongs to
[Dynamic Table]
table(s), and can therefore be used via those table(s).