GET api/Datasets/GetDatasets

Request Information

URI Parameters

None.

Body Parameters

None.

Response Information

Resource Description

Collection of Dataset

Name	Type	Additional information
id	string	None.
name	string	None.
configuredBy	string	None.
defaultRetentionPolicy	string	None.
addRowsAPIEnabled	boolean	None.
tables	Collection of Table	None.
webUrl	string	None.
relationships	Collection of Relationship	None.
datasources	Collection of Datasource	None.
defaultMode	string	None.
IsRefreshable	boolean	None.
IsEffectiveIdentityRequired	boolean	None.
IsEffectiveIdentityRolesRequired	boolean	None.
IsOnPremGatewayRequired	boolean	None.

Response Formats

application/json, text/json

Sample:

[
  {
    "id": "sample string 1",
    "name": "sample string 2",
    "configuredBy": "sample string 3",
    "defaultRetentionPolicy": "sample string 4",
    "addRowsAPIEnabled": true,
    "tables": [
      {
        "name": "sample string 1",
        "columns": [
          {
            "name": "sample string 1",
            "dataType": "sample string 2"
          },
          {
            "name": "sample string 1",
            "dataType": "sample string 2"
          }
        ],
        "rows": [
          {
            "id": "sample string 1"
          },
          {
            "id": "sample string 1"
          }
        ],
        "measures": [
          {
            "name": "sample string 1",
            "expression": "sample string 2"
          },
          {
            "name": "sample string 1",
            "expression": "sample string 2"
          }
        ]
      },
      {
        "name": "sample string 1",
        "columns": [
          {
            "name": "sample string 1",
            "dataType": "sample string 2"
          },
          {
            "name": "sample string 1",
            "dataType": "sample string 2"
          }
        ],
        "rows": [
          {
            "id": "sample string 1"
          },
          {
            "id": "sample string 1"
          }
        ],
        "measures": [
          {
            "name": "sample string 1",
            "expression": "sample string 2"
          },
          {
            "name": "sample string 1",
            "expression": "sample string 2"
          }
        ]
      }
    ],
    "webUrl": "sample string 5",
    "relationships": [
      {
        "name": "sample string 1",
        "crossFilteringBehavior": "OneDirection",
        "fromTable": "sample string 2",
        "fromColumn": "sample string 3",
        "toTable": "sample string 4",
        "toColumn": "sample string 5"
      },
      {
        "name": "sample string 1",
        "crossFilteringBehavior": "OneDirection",
        "fromTable": "sample string 2",
        "fromColumn": "sample string 3",
        "toTable": "sample string 4",
        "toColumn": "sample string 5"
      }
    ],
    "datasources": [
      {
        "name": "sample string 1",
        "connectionString": "sample string 2",
        "datasourceType": "sample string 3",
        "connectionDetails": {
          "server": "sample string 1",
          "database": "sample string 2",
          "url": "sample string 3"
        },
        "gatewayId": "sample string 4",
        "datasourceId": "sample string 5"
      },
      {
        "name": "sample string 1",
        "connectionString": "sample string 2",
        "datasourceType": "sample string 3",
        "connectionDetails": {
          "server": "sample string 1",
          "database": "sample string 2",
          "url": "sample string 3"
        },
        "gatewayId": "sample string 4",
        "datasourceId": "sample string 5"
      }
    ],
    "defaultMode": "sample string 6",
    "IsRefreshable": true,
    "IsEffectiveIdentityRequired": true,
    "IsEffectiveIdentityRolesRequired": true,
    "IsOnPremGatewayRequired": true
  },
  {
    "id": "sample string 1",
    "name": "sample string 2",
    "configuredBy": "sample string 3",
    "defaultRetentionPolicy": "sample string 4",
    "addRowsAPIEnabled": true,
    "tables": [
      {
        "name": "sample string 1",
        "columns": [
          {
            "name": "sample string 1",
            "dataType": "sample string 2"
          },
          {
            "name": "sample string 1",
            "dataType": "sample string 2"
          }
        ],
        "rows": [
          {
            "id": "sample string 1"
          },
          {
            "id": "sample string 1"
          }
        ],
        "measures": [
          {
            "name": "sample string 1",
            "expression": "sample string 2"
          },
          {
            "name": "sample string 1",
            "expression": "sample string 2"
          }
        ]
      },
      {
        "name": "sample string 1",
        "columns": [
          {
            "name": "sample string 1",
            "dataType": "sample string 2"
          },
          {
            "name": "sample string 1",
            "dataType": "sample string 2"
          }
        ],
        "rows": [
          {
            "id": "sample string 1"
          },
          {
            "id": "sample string 1"
          }
        ],
        "measures": [
          {
            "name": "sample string 1",
            "expression": "sample string 2"
          },
          {
            "name": "sample string 1",
            "expression": "sample string 2"
          }
        ]
      }
    ],
    "webUrl": "sample string 5",
    "relationships": [
      {
        "name": "sample string 1",
        "crossFilteringBehavior": "OneDirection",
        "fromTable": "sample string 2",
        "fromColumn": "sample string 3",
        "toTable": "sample string 4",
        "toColumn": "sample string 5"
      },
      {
        "name": "sample string 1",
        "crossFilteringBehavior": "OneDirection",
        "fromTable": "sample string 2",
        "fromColumn": "sample string 3",
        "toTable": "sample string 4",
        "toColumn": "sample string 5"
      }
    ],
    "datasources": [
      {
        "name": "sample string 1",
        "connectionString": "sample string 2",
        "datasourceType": "sample string 3",
        "connectionDetails": {
          "server": "sample string 1",
          "database": "sample string 2",
          "url": "sample string 3"
        },
        "gatewayId": "sample string 4",
        "datasourceId": "sample string 5"
      },
      {
        "name": "sample string 1",
        "connectionString": "sample string 2",
        "datasourceType": "sample string 3",
        "connectionDetails": {
          "server": "sample string 1",
          "database": "sample string 2",
          "url": "sample string 3"
        },
        "gatewayId": "sample string 4",
        "datasourceId": "sample string 5"
      }
    ],
    "defaultMode": "sample string 6",
    "IsRefreshable": true,
    "IsEffectiveIdentityRequired": true,
    "IsEffectiveIdentityRolesRequired": true,
    "IsOnPremGatewayRequired": true
  }
]

application/xml, text/xml

Sample:

<ArrayOfDataset xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Microsoft.PowerBI.Api.V2.Models">
  <Dataset>
    <AddRowsAPIEnabled>true</AddRowsAPIEnabled>
    <ConfiguredBy>sample string 3</ConfiguredBy>
    <Datasources>
      <Datasource>
        <ConnectionDetails>
          <Database>sample string 2</Database>
          <Server>sample string 1</Server>
          <Url>sample string 3</Url>
        </ConnectionDetails>
        <ConnectionString>sample string 2</ConnectionString>
        <DatasourceId>sample string 5</DatasourceId>
        <DatasourceType>sample string 3</DatasourceType>
        <GatewayId>sample string 4</GatewayId>
        <Name>sample string 1</Name>
      </Datasource>
      <Datasource>
        <ConnectionDetails>
          <Database>sample string 2</Database>
          <Server>sample string 1</Server>
          <Url>sample string 3</Url>
        </ConnectionDetails>
        <ConnectionString>sample string 2</ConnectionString>
        <DatasourceId>sample string 5</DatasourceId>
        <DatasourceType>sample string 3</DatasourceType>
        <GatewayId>sample string 4</GatewayId>
        <Name>sample string 1</Name>
      </Datasource>
    </Datasources>
    <DefaultMode>sample string 6</DefaultMode>
    <DefaultRetentionPolicy>sample string 4</DefaultRetentionPolicy>
    <Id>sample string 1</Id>
    <IsEffectiveIdentityRequired>true</IsEffectiveIdentityRequired>
    <IsEffectiveIdentityRolesRequired>true</IsEffectiveIdentityRolesRequired>
    <IsOnPremGatewayRequired>true</IsOnPremGatewayRequired>
    <IsRefreshable>true</IsRefreshable>
    <Name>sample string 2</Name>
    <Relationships>
      <Relationship>
        <CrossFilteringBehavior>OneDirection</CrossFilteringBehavior>
        <FromColumn>sample string 3</FromColumn>
        <FromTable>sample string 2</FromTable>
        <Name>sample string 1</Name>
        <ToColumn>sample string 5</ToColumn>
        <ToTable>sample string 4</ToTable>
      </Relationship>
      <Relationship>
        <CrossFilteringBehavior>OneDirection</CrossFilteringBehavior>
        <FromColumn>sample string 3</FromColumn>
        <FromTable>sample string 2</FromTable>
        <Name>sample string 1</Name>
        <ToColumn>sample string 5</ToColumn>
        <ToTable>sample string 4</ToTable>
      </Relationship>
    </Relationships>
    <Tables>
      <Table>
        <Columns>
          <Column>
            <DataType>sample string 2</DataType>
            <Name>sample string 1</Name>
          </Column>
          <Column>
            <DataType>sample string 2</DataType>
            <Name>sample string 1</Name>
          </Column>
        </Columns>
        <Measures>
          <Measure>
            <Expression>sample string 2</Expression>
            <Name>sample string 1</Name>
          </Measure>
          <Measure>
            <Expression>sample string 2</Expression>
            <Name>sample string 1</Name>
          </Measure>
        </Measures>
        <Name>sample string 1</Name>
        <Rows>
          <Row>
            <Id>sample string 1</Id>
          </Row>
          <Row>
            <Id>sample string 1</Id>
          </Row>
        </Rows>
      </Table>
      <Table>
        <Columns>
          <Column>
            <DataType>sample string 2</DataType>
            <Name>sample string 1</Name>
          </Column>
          <Column>
            <DataType>sample string 2</DataType>
            <Name>sample string 1</Name>
          </Column>
        </Columns>
        <Measures>
          <Measure>
            <Expression>sample string 2</Expression>
            <Name>sample string 1</Name>
          </Measure>
          <Measure>
            <Expression>sample string 2</Expression>
            <Name>sample string 1</Name>
          </Measure>
        </Measures>
        <Name>sample string 1</Name>
        <Rows>
          <Row>
            <Id>sample string 1</Id>
          </Row>
          <Row>
            <Id>sample string 1</Id>
          </Row>
        </Rows>
      </Table>
    </Tables>
    <WebUrl>sample string 5</WebUrl>
  </Dataset>
  <Dataset>
    <AddRowsAPIEnabled>true</AddRowsAPIEnabled>
    <ConfiguredBy>sample string 3</ConfiguredBy>
    <Datasources>
      <Datasource>
        <ConnectionDetails>
          <Database>sample string 2</Database>
          <Server>sample string 1</Server>
          <Url>sample string 3</Url>
        </ConnectionDetails>
        <ConnectionString>sample string 2</ConnectionString>
        <DatasourceId>sample string 5</DatasourceId>
        <DatasourceType>sample string 3</DatasourceType>
        <GatewayId>sample string 4</GatewayId>
        <Name>sample string 1</Name>
      </Datasource>
      <Datasource>
        <ConnectionDetails>
          <Database>sample string 2</Database>
          <Server>sample string 1</Server>
          <Url>sample string 3</Url>
        </ConnectionDetails>
        <ConnectionString>sample string 2</ConnectionString>
        <DatasourceId>sample string 5</DatasourceId>
        <DatasourceType>sample string 3</DatasourceType>
        <GatewayId>sample string 4</GatewayId>
        <Name>sample string 1</Name>
      </Datasource>
    </Datasources>
    <DefaultMode>sample string 6</DefaultMode>
    <DefaultRetentionPolicy>sample string 4</DefaultRetentionPolicy>
    <Id>sample string 1</Id>
    <IsEffectiveIdentityRequired>true</IsEffectiveIdentityRequired>
    <IsEffectiveIdentityRolesRequired>true</IsEffectiveIdentityRolesRequired>
    <IsOnPremGatewayRequired>true</IsOnPremGatewayRequired>
    <IsRefreshable>true</IsRefreshable>
    <Name>sample string 2</Name>
    <Relationships>
      <Relationship>
        <CrossFilteringBehavior>OneDirection</CrossFilteringBehavior>
        <FromColumn>sample string 3</FromColumn>
        <FromTable>sample string 2</FromTable>
        <Name>sample string 1</Name>
        <ToColumn>sample string 5</ToColumn>
        <ToTable>sample string 4</ToTable>
      </Relationship>
      <Relationship>
        <CrossFilteringBehavior>OneDirection</CrossFilteringBehavior>
        <FromColumn>sample string 3</FromColumn>
        <FromTable>sample string 2</FromTable>
        <Name>sample string 1</Name>
        <ToColumn>sample string 5</ToColumn>
        <ToTable>sample string 4</ToTable>
      </Relationship>
    </Relationships>
    <Tables>
      <Table>
        <Columns>
          <Column>
            <DataType>sample string 2</DataType>
            <Name>sample string 1</Name>
          </Column>
          <Column>
            <DataType>sample string 2</DataType>
            <Name>sample string 1</Name>
          </Column>
        </Columns>
        <Measures>
          <Measure>
            <Expression>sample string 2</Expression>
            <Name>sample string 1</Name>
          </Measure>
          <Measure>
            <Expression>sample string 2</Expression>
            <Name>sample string 1</Name>
          </Measure>
        </Measures>
        <Name>sample string 1</Name>
        <Rows>
          <Row>
            <Id>sample string 1</Id>
          </Row>
          <Row>
            <Id>sample string 1</Id>
          </Row>
        </Rows>
      </Table>
      <Table>
        <Columns>
          <Column>
            <DataType>sample string 2</DataType>
            <Name>sample string 1</Name>
          </Column>
          <Column>
            <DataType>sample string 2</DataType>
            <Name>sample string 1</Name>
          </Column>
        </Columns>
        <Measures>
          <Measure>
            <Expression>sample string 2</Expression>
            <Name>sample string 1</Name>
          </Measure>
          <Measure>
            <Expression>sample string 2</Expression>
            <Name>sample string 1</Name>
          </Measure>
        </Measures>
        <Name>sample string 1</Name>
        <Rows>
          <Row>
            <Id>sample string 1</Id>
          </Row>
          <Row>
            <Id>sample string 1</Id>
          </Row>
        </Rows>
      </Table>
    </Tables>
    <WebUrl>sample string 5</WebUrl>
  </Dataset>
</ArrayOfDataset>