EndPoint Get Table Rows
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:
Get Table Rows using API Source
Power BI
Get Table Rows

Get Table Rows using API Destination
Power BI
Get Table Rows

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')
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 [LINKED_SERVER_TO_POWER_BI_IN_DATA_GATEWAY];
Tables - Get Table rows
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT *
FROM get_table_rows
WITH (TableName=''MyTable'')';
EXEC (@MyQuery) AT [LINKED_SERVER_TO_POWER_BI_IN_DATA_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 [LINKED_SERVER_TO_POWER_BI_IN_DATA_GATEWAY];