แชร์ผ่าน


Admin - WorkspaceInfo GetScanResult

Gets the scan result for the specified scan.

Only make this API call after a successful GetScanStatus API call. The scan result will remain available for 24 hours.

Permissions

The user must be a Fabric administrator or authenticate using a service principal.

When running under service principal authentication, an app must not have any admin-consent required permissions for Power BI set on it in the Azure portal.

Required Scope

Tenant.Read.All or Tenant.ReadWrite.All

Relevant only when authenticating via a standard delegated admin access token. Must not be present when authentication via a service principal is used.

Limitations

Maximum 500 requests per hour.

GET https://api.powerbi.com/v1.0/myorg/admin/workspaces/scanResult/{scanId}

URI Parameters

Name In Required Type Description
scanId
path True

string

uuid

The scan ID, which is included in the response from the workspaces or the Admin - WorkspaceInfo PostWorkspaceInfo API call that triggered the scan.

Responses

Name Type Description
200 OK

WorkspaceInfoResponse

OK

Examples

Example

Sample request

GET https://api.powerbi.com/v1.0/myorg/admin/workspaces/scanResult/e7d03602-4873-4760-b37e-1563ef5358e3

Sample response

{
  "workspaces": [
    {
      "id": "d507422c-8d6d-4361-ac7a-30074a8cd0a1",
      "name": "V2 shared",
      "type": "Workspace",
      "state": "Active",
      "isOnDedicatedCapacity": true,
      "capacityId": "0f084df7-c13d-451b-af5f-ed0c466403b2",
      "defaultDatasetStorageFormat": "Small",
      "reports": [
        {
          "id": "c6d072d1-ed20-4b60-8329-16c4b934203b",
          "name": "CompositeModelParams-RLS",
          "datasetId": "132593c4-bf8d-4548-8f25-1ebb16a1613c",
          "createdDateTime": "2020-06-16T08:22:49.14",
          "modifiedDateTime": "2020-06-16T08:22:49.14",
          "modifiedBy": "john@contoso.com",
          "reportType": "PaginatedReport",
          "endorsementDetails": {
            "endorsement": "Certified",
            "certifiedBy": "john@contoso.com"
          },
          "sensitivityLabel": {
            "labelId": "85b38049-4259-43a2-8feb-244e222d96c0"
          },
          "users": [
            {
              "displayName": "John Nick",
              "emailAddress": "john@contoso.com",
              "appUserAccessRight": "ReadExplore",
              "identifier": "john@contoso.com",
              "graphId": "3fadb6e4-130c-4a8f-aeac-416e38b66756",
              "principalType": "User"
            }
          ]
        }
      ],
      "dashboards": [
        {
          "id": "80814ece-9302-49e3-b6bc-bad2f7a86c1a",
          "displayName": "CompositeModelParamsDashboard",
          "isReadOnly": false,
          "tiles": [
            {
              "id": "e687cc21-5b32-48f5-8c5e-4b844f190579",
              "title": "CompositeModelParamsDashboard",
              "reportId": "c6d072d1-ed20-4b60-8329-16c4b934203b",
              "datasetId": "132593c4-bf8d-4548-8f25-1ebb16a1613c"
            }
          ],
          "sensitivityLabel": {
            "labelId": "d9b9581a-0594-4c39-81c5-91ddf40baeda"
          },
          "users": [
            {
              "displayName": "John Nick",
              "emailAddress": "john@contoso.com",
              "appUserAccessRight": "ReadExplore",
              "identifier": "john@contoso.com",
              "graphId": "3fadb6e4-130c-4a8f-aeac-416e38b66756",
              "principalType": "User"
            }
          ]
        }
      ],
      "datasets": [
        {
          "id": "e7e8a355-e77b-4418-a7b8-ae5972fdaa03",
          "name": "ExportB",
          "tables": [
            {
              "name": "DW_Revenues",
              "columns": [
                {
                  "name": "RowNumber-2662979B-1795-4F74-8F37-6A1BA8059B61",
                  "dataType": "Int64",
                  "isHidden": true
                }
              ],
              "measures": [
                {
                  "name": "MyMeasure",
                  "expression": "CALCULATE(SELECTEDVALUE('DW_Revenues DW_RevenuesTestToBeDeleted'[Numbers])*10)",
                  "description": "My measure",
                  "isHidden": false
                }
              ],
              "isHidden": false,
              "description": "My table",
              "source": [
                {
                  "expression": "let\n    Source = Revenues,\n    Param = RevenuesParam\nin\n    Source"
                }
              ]
            }
          ],
          "relationships": [],
          "configuredBy": "john@contoso.com",
          "targetStorageMode": "Abf",
          "endorsementDetails": {
            "endorsement": "Certified",
            "certifiedBy": "john@contoso.com"
          },
          "expressions": [
            {
              "name": "Revenues",
              "description": "revenues",
              "expression": "let\n    Source = Sql.Database(\"sqlserver.database.windows.net\", \"DB\"),\n    RevenuesTable = Source{[Schema=\"DB_SCHEMA\",Item=\"DB_SCHEMA_ITEM\"]}[Data]\nin\n    RevenuesTable"
            },
            {
              "name": "RevenuesParam",
              "description": "revenues param",
              "expression": "\"revenues param value\" meta [IsParameterQuery=true, Type=\"Text\", IsParameterQueryRequired=true]"
            }
          ],
          "roles": [
            {
              "name": "Teams",
              "modelPermission": "Read",
              "members": [
                {
                  "memberName": "john@contoso.com",
                  "memberId": "ee96296b-fb71-4f65-a8af-c0ec5a7daced",
                  "memberType": "User",
                  "identityProvider": "AzureAD"
                },
                {
                  "memberName": "group@contoso.com",
                  "memberId": "0a1cdbc3-f82c-4001-8b96-be04ae9d25a3",
                  "memberType": "Group",
                  "identityProvider": "AzureAD"
                }
              ],
              "tablePermissions": [
                {
                  "name": "DW_Revenues DW_RevenuesTest",
                  "filterExpression": "[InTeams] = \"True\""
                }
              ]
            }
          ],
          "upstreamDataflows": [
            {
              "targetDataflowId": "a842dbb1-32ca-46b0-9648-498b2c2d5e38",
              "groupId": "b7416115-7421-42c0-b525-1505ce40d2f0"
            },
            {
              "targetDataflowId": "06898194-2eaf-4122-bacc-133db1f8585d",
              "groupId": "7263838d-80d7-4b8d-a1f6-50fc27e74a97"
            }
          ],
          "datasourceUsages": [
            {
              "datasourceInstanceId": "c79ad907-df19-43fe-a0f7-d9f365d67070"
            }
          ],
          "misconfiguredDatasourceUsages": [
            {
              "datasourceInstanceId": "80ec28bc-fe81-43ea-be52-a07a95cfbcab"
            }
          ],
          "sensitivityLabel": {
            "labelId": "bf3dc57d-d796-41c0-bbe9-a47f5ee3331e"
          },
          "users": [
            {
              "displayName": "John Nick",
              "emailAddress": "john@contoso.com",
              "appUserAccessRight": "ReadExplore",
              "identifier": "john@contoso.com",
              "graphId": "3fadb6e4-130c-4a8f-aeac-416e38b66756",
              "principalType": "User"
            }
          ]
        }
      ],
      "dataflows": [
        {
          "objectId": "a842dbb1-32ca-46b0-9648-498b2c2d5e38",
          "name": "Azure SQL",
          "description": "Azure SQL dataflow",
          "configuredBy": "john@contoso.com",
          "modifiedBy": "john@contoso.com",
          "modifiedDateTime": "2020-06-16T08:27:47.783Z",
          "endorsementDetails": {
            "endorsement": "Certified",
            "certifiedBy": "john@contoso.com"
          },
          "datasourceUsages": [
            {
              "datasourceInstanceId": "c79ad907-df19-43fe-a0f7-d9f365d67070"
            }
          ],
          "misconfiguredDatasourceUsages": [
            {
              "datasourceInstanceId": "80ec28bc-fe81-43ea-be52-a07a95cfbcab"
            }
          ],
          "sensitivityLabel": {
            "labelId": "5c9f8c24-2a94-4fd2-a105-9a8b096c5af1"
          },
          "users": [
            {
              "displayName": "John Nick",
              "emailAddress": "john@contoso.com",
              "appUserAccessRight": "ReadExplore",
              "identifier": "john@contoso.com",
              "graphId": "3fadb6e4-130c-4a8f-aeac-416e38b66756",
              "principalType": "User"
            }
          ]
        }
      ],
      "datamarts": [
        {
          "id": "9df8d63c-db5b-44c3-a8e3-9f8c8ec1eec2",
          "name": "MyDatamart",
          "description": "SQL datamart",
          "type": "Sql",
          "configuredBy": "john@contoso.com",
          "configuredById": "5c9f8c24-2a94-4fd2-a105-9a8b096cdsew",
          "modifiedBy": "john@contoso.com",
          "modifiedDateTime": "2020-06-16T08:27:47.783Z",
          "sensitivityLabel": {
            "labelId": "5c9f8c24-2a94-4fd2-a105-9a8b096c5af1"
          },
          "endorsementDetails": {
            "endorsement": "Certified",
            "certifiedBy": "john@contoso.com"
          },
          "UpstreamDataflows": [
            {
              "targetDataflowId": "5c9f8c24-2a94-34fd-a105-9a8b096c4555",
              "groupId": "5c9f8c24-4dsc-4fd2-a105-9a8b096c4fgt"
            }
          ],
          "datasourceUsages": [
            {
              "datasourceInstanceId": "c79ad907-df19-43fe-a0f7-d9f365d67070"
            }
          ],
          "Users": [
            {
              "displayName": "John Nick",
              "emailAddress": "john@contoso.com",
              "identifier": "john@contoso.com",
              "graphId": "3fadb6e4-130c-4a8f-aeac-416e38b66756",
              "principalType": "User",
              "userType": "User",
              "profile": {
                "id": "45416453",
                "displayName": "John's profile"
              },
              "datamartUserAccessRight": "Read"
            }
          ]
        }
      ],
      "users": [
        {
          "displayName": "John Nick",
          "emailAddress": "john@contoso.com",
          "appUserAccessRight": "ReadExplore",
          "identifier": "john@contoso.com",
          "graphId": "3fadb6e4-130c-4a8f-aeac-416e38b66756",
          "principalType": "User"
        }
      ]
    }
  ],
  "datasourceInstances": [
    {
      "datasourceType": "Sql",
      "connectionDetails": {
        "server": "qlserver.database.windows.net",
        "database": "dbo.largest_table"
      },
      "datasourceId": "c79ad907-df19-43fe-a0f7-d9f365d67070",
      "gatewayId": "e820592e-f8cf-4a6f-b1ed-566799d29565"
    }
  ],
  "misconfiguredDatasourceInstances": [
    {
      "datasourceType": "Sql",
      "connectionDetails": {
        "server": "sqlserver.database.windows.net",
        "database": "dbo.table"
      },
      "datasourceId": "80ec28bc-fe81-43ea-be52-a07a95cfbcab",
      "gatewayId": "505a19c1-4190-4e8e-a4f6-dd72722feced"
    }
  ]
}

Definitions

Name Description
ASMashupExpression

A dataset table source

Column

A dataset column

DashboardUser

A Power BI user access right entry for a dashboard

DashboardUserAccessRight

The access right that the user has for the dashboard (permission level)

DataflowUser

A Power BI user access right entry for a dataflow

DataflowUserAccessRight

The access right that a user has for the dataflow (permission level)

datamartState

The datamart current state

datamartStatus

The datamart status

datamartType

The datamart type

DatamartUser

A Power BI user access right entry for a report

DatamartUserAccessRight

The access right that the user has for the datamart (permission level)

DatasetUser

A Power BI user access right entry for a dataset

DatasetUserAccessRight

The access right that the user has for the dataset (permission level)

Datasource

A Power BI data source

DatasourceConnectionDetails

The Power BI data source connection details. See examples in Get Datasources or Get Datasources In Group.

DatasourceUsage

Data source usage

DefaultDatasetStorageFormat

The default dataset storage format in the group

DependentDataflow

A Power BI dependent dataflow

DependentDatamart

A Power BI dependent datamart

DependentDataset

A Power BI dependent dataset

EndorsementDetails

Power BI endorsement details

Expression

A dataset expression

GroupUser

A Power BI user with access to the workspace

GroupUserAccessRight

The access right (permission level) that a user has on the workspace

Measure

A Power BI measure

PrincipalType

The principal type

ReportUser

A Power BI user access right entry for a report

ReportUserAccessRight

The access right that the user has for the report (permission level)

Role

A role in a dataset’s RLS configuration

RoleMember

A role member

RoleTablePermission

A role filter

Row

A data row in a dataset

SensitivityLabel

Sensitivity label info for a Power BI item (such as a report or a dashboard)

ServicePrincipalProfile

A Power BI service principal profile. Only relevant for Power BI Embedded multi-tenancy solution.

Table

A dataset table

WorkspaceInfo

Workspace info details

WorkspaceInfoDashboard

A Power BI dashboard returned by WorkspaceInfo APIs. The API returns a subset of the following list of dashboard properties. The subset depends on the API called, caller permissions, and the availability of data in the Power BI database.

WorkspaceInfoDataflow

The metadata of a dataflow returned by Workspace Info APIs. Below is a list of properties that may be returned for a dataflow. Only a subset of the properties will be returned depending on the API called, the caller permissions and the availability of the data in the Power BI database.

WorkspaceInfoDatamart

A Power BI datamart returned by Workspace Info APIs. The API returns a subset of the following list of datamart properties. The subset depends on the API called, caller permissions, and the availability of data in the Power BI database.

WorkspaceInfoDataset

A Power BI dataset returned by WorkspaceInfo APIs. The API returns a subset of the following list of dataset properties. The subset depends on the API called, caller permissions, and the availability of the data in the Power BI database.

WorkspaceInfoReport

A Power BI report returned by Workspace Info APIs. The API returns a subset of the following list of report properties. The subset depends on the API called, caller permissions, and the availability of data in the Power BI database.

WorkspaceInfoResponse

Workspace info response

WorkspaceInfoTile

A Power BI tile returned by WorkspaceInfo APIs

ASMashupExpression

A dataset table source

Name Type Description
expression

string

The source expression

Column

A dataset column

Name Type Description
dataCategory

string

Optional. The string value to be used for the data category which describes the data within this column.

dataType

string

The column data type

formatString

string

Optional. The format of the column as specified in FORMAT_STRING.

isHidden

boolean

Optional. Whether the column is hidden. The default is false.

name

string

The column name

sortByColumn

string

Optional. String name of a column in the same table to be used to order the current column.

summarizeBy

string

Optional. The aggregate function to use for summarizing this column.

DashboardUser

A Power BI user access right entry for a dashboard

Name Type Description
dashboardUserAccessRight

DashboardUserAccessRight

The access right that the user has for the dashboard (permission level)

displayName

string

Display name of the principal

emailAddress

string

Email address of the user

graphId

string

Identifier of the principal in Microsoft Graph. Only available for admin APIs.

identifier

string

Identifier of the principal

principalType

PrincipalType

The principal type

profile

ServicePrincipalProfile

A Power BI service principal profile. Only relevant for Power BI Embedded multi-tenancy solution.

userType

string

Type of the user.

DashboardUserAccessRight

The access right that the user has for the dashboard (permission level)

Name Type Description
None

string

No permission to content in dashboard

Owner

string

Grants Read, Write and Reshare access to content in report

Read

string

Grants Read access to content in dashboard

ReadCopy

string

Grants Read and Copy access to content in dashboard

ReadReshare

string

Grants Read and Reshare access to content in dashboard

ReadWrite

string

Grants Read and Write access to content in dashboard

DataflowUser

A Power BI user access right entry for a dataflow

Name Type Description
DataflowUserAccessRight

DataflowUserAccessRight

The access right that a user has for the dataflow (permission level)

displayName

string

Display name of the principal

emailAddress

string

Email address of the user

graphId

string

Identifier of the principal in Microsoft Graph. Only available for admin APIs.

identifier

string

Identifier of the principal

principalType

PrincipalType

The principal type

profile

ServicePrincipalProfile

A Power BI service principal profile. Only relevant for Power BI Embedded multi-tenancy solution.

userType

string

Type of the user.

DataflowUserAccessRight

The access right that a user has for the dataflow (permission level)

Name Type Description
None

string

Removes permission to content in dataflow

Owner

string

Grants Read, Write and Reshare access to content in dataflow

Read

string

Grants Read access to content in dataflow

ReadReshare

string

Grants Read and Reshare access to content in dataflow

ReadWrite

string

Grants Read and Write access to content in dataflow

datamartState

The datamart current state

Name Type Description
Active

string

The datamart is active

Deleted

string

The datamart was deleted

Evicted

string

The datamart was evicted

Initialized

string

The datamart was initialized

Invalid

string

The datamart has invalid state

Migrating

string

The datamart is migrating

datamartStatus

The datamart status

Name Type Description
Available

string

The datamart is available

Error

string

The datamart has error status

InProgress

string

The datamart is in progress

Invalid

string

The datamart has invalid status

NoCapacity

string

The datamart has no capacity

OutOfRegion

string

The datamart is out of region

SuspendedInCriticalPhase

string

The datamart is suspended in critical phase

datamartType

The datamart type

Name Type Description
Dataverse

string

The datamart is of Dataverse type

Datawarehouse

string

The datamart is of Datawarehouse type

Ignore

string

The datamart has no type

Lakehouse

string

The datamart is of Lakehouse type

Sql

string

The datamart is of Sql type

Unset

string

The datamart type was unset

DatamartUser

A Power BI user access right entry for a report

Name Type Description
datamartUserAccessRight

DatamartUserAccessRight

The access right that the user has for the datamart (permission level)

displayName

string

Display name of the principal

emailAddress

string

Email address of the user

graphId

string

Identifier of the principal in Microsoft Graph. Only available for admin APIs.

identifier

string

Identifier of the principal

principalType

PrincipalType

The principal type

profile

ServicePrincipalProfile

A Power BI service principal profile. Only relevant for Power BI Embedded multi-tenancy solution.

userType

string

Type of the user.

DatamartUserAccessRight

The access right that the user has for the datamart (permission level)

Name Type Description
Explore

string

Grants explore access to content in datamart

None

string

No permission to content in datamart

Read

string

Grants Read access to content in datamart

ReadExplore

string

Grants read and explore access to content in datamart

ReadReshare

string

Grants read and reshare access to content in datamart

ReadReshareExplore

string

Grants read and reshare and explore access to content in datamart

ReadWrite

string

Grants read and write access to content in datamart

ReadWriteExplore

string

Grants read and write and explore access to content in datamart

ReadWriteReshare

string

Grants read and write and reshare access to content in datamart

ReadWriteReshareExplore

string

Grants read and write and reshare and explore access to content in datamart

Reshare

string

Grants reshare access to content in datamart

Write

string

Grants write access to content in datamart

DatasetUser

A Power BI user access right entry for a dataset

Name Type Description
datasetUserAccessRight

DatasetUserAccessRight

The access right that the user has for the dataset (permission level)

displayName

string

Display name of the principal

emailAddress

string

Email address of the user

graphId

string

Identifier of the principal in Microsoft Graph. Only available for admin APIs.

identifier

string

Identifier of the principal

principalType

PrincipalType

The principal type

profile

ServicePrincipalProfile

A Power BI service principal profile. Only relevant for Power BI Embedded multi-tenancy solution.

userType

string

Type of the user.

DatasetUserAccessRight

The access right that the user has for the dataset (permission level)

Name Type Description
None

string

Removes permission to the content in the dataset

Read

string

Grants Read access to the content in the dataset

ReadExplore

string

Grants Read and Explore access to the content in the dataset

ReadReshare

string

Grants Read and Reshare access to the content in the dataset

ReadReshareExplore

string

Grants Read, Reshare, and Explore access to the content in the dataset

ReadWrite

string

Grants Read and Write access to the content in the dataset

ReadWriteExplore

string

Grants Read, Write, and Explore access to the content in the dataset

ReadWriteReshare

string

Grants Read, Write, and Reshare access to the content in the dataset

ReadWriteReshareExplore

string

Grants Read, Write, Reshare, and Explore access to the content in the dataset

Datasource

A Power BI data source

Name Type Description
connectionDetails

DatasourceConnectionDetails

The data source connection details

connectionString

string

(Deprecated) The data source connection string. Available only for DirectQuery.

datasourceId

string

The bound data source ID, which is empty when not bound to a gateway

datasourceType

string

The data source type

gatewayId

string

The bound gateway ID, which is empty when not bound to a gateway. When using a gateway cluster, the gateway ID refers to the primary (first) gateway in the cluster and is similar to the gateway cluster ID.

name

string

(Deprecated) The data source name. Available only for DirectQuery.

DatasourceConnectionDetails

The Power BI data source connection details. See examples in Get Datasources or Get Datasources In Group.

Name Type Description
account

string

The connection account

classInfo

string

The connection class information

database

string

The connection database

domain

string

The connection domain

emailAddress

string

The connection email address

kind

string

The connection kind

loginServer

string

The connection login server

path

string

The connection path

server

string

The connection server

url

string

The connection URL

DatasourceUsage

Data source usage

Name Type Description
datasourceInstanceId

string

The data source instance ID

DefaultDatasetStorageFormat

The default dataset storage format in the group

Name Type Description
Large

string

Large dataset storage format

Small

string

Small dataset storage format

DependentDataflow

A Power BI dependent dataflow

Name Type Description
groupId

string

The target group ID

targetDataflowId

string

The target dataflow ID

DependentDatamart

A Power BI dependent datamart

Name Type Description
groupId

string

The target group ID

targetDatamartId

string

The target datamart ID

DependentDataset

A Power BI dependent dataset

Name Type Description
groupId

string

The target group ID

targetDatasetId

string

The target dataset ID

EndorsementDetails

Power BI endorsement details

Name Type Description
certifiedBy

string

The user that certified the Power BI item (such as a report or a dashboard)

endorsement

string

The endorsement status

Expression

A dataset expression

Name Type Description
description

string

The expression description

expression

string

The expression value

name

string

The expression name

GroupUser

A Power BI user with access to the workspace

Name Type Description
displayName

string

Display name of the principal

emailAddress

string

Email address of the user

graphId

string

Identifier of the principal in Microsoft Graph. Only available for admin APIs.

groupUserAccessRight

GroupUserAccessRight

The access right (permission level) that a user has on the workspace

identifier

string

Identifier of the principal

principalType

PrincipalType

The principal type

profile

ServicePrincipalProfile

A Power BI service principal profile. Only relevant for Power BI Embedded multi-tenancy solution.

userType

string

Type of the user.

GroupUserAccessRight

The access right (permission level) that a user has on the workspace

Name Type Description
Admin

string

Administrator rights to workspace content

Contributor

string

Read and explore (ReadExplore) access to workspace content

Member

string

Read, reshare and explore (ReadReshareExplore) access rights to workspace content

None

string

No access to workspace content

Viewer

string

Read-only (Read) access to workspace content

Measure

A Power BI measure

Name Type Description
description

string

Optional. The measure description.

expression

string

A valid DAX expression

formatString

string

Optional. A string describing how the value should be formatted when it's displayed as specified in FORMAT_STRING.

isHidden

boolean

Optional. Whether the measure is hidden.

name

string

The measure name

PrincipalType

The principal type

Name Type Description
App

string

Service principal type

Group

string

Group principal type

None

string

No principal type. Use for whole organization level access.

User

string

User principal type

ReportUser

A Power BI user access right entry for a report

Name Type Description
displayName

string

Display name of the principal

emailAddress

string

Email address of the user

graphId

string

Identifier of the principal in Microsoft Graph. Only available for admin APIs.

identifier

string

Identifier of the principal

principalType

PrincipalType

The principal type

profile

ServicePrincipalProfile

A Power BI service principal profile. Only relevant for Power BI Embedded multi-tenancy solution.

reportUserAccessRight

ReportUserAccessRight

The access right that the user has for the report (permission level)

userType

string

Type of the user.

ReportUserAccessRight

The access right that the user has for the report (permission level)

Name Type Description
None

string

No permission to content in report

Owner

string

Grants Read, Write and Reshare access to content in report

Read

string

Grants Read access to content in report

ReadCopy

string

Grants Read and Copy access to content in report

ReadReshare

string

Grants Read and Reshare access to content in report

ReadWrite

string

Grants Read and Write access to content in report

Role

A role in a dataset’s RLS configuration

Name Type Description
members

RoleMember

An array listing the members of the role

modelPermission

string

The permissions that the role has on the dataset. For example, Read

name

string

The name of the role

tablePermissions

RoleTablePermission

An array that lists all the filters defined for the role

RoleMember

A role member

Name Type Description
identityProvider

string

The role member identity provider

memberId

string

The role member GUID as assigned by the identity provider

memberName

string

The name of the role member

memberType

string

The role member type (user or group)

RoleTablePermission

A role filter

Name Type Description
filterExpression

string

The expression that filters the table specified in the filter

name

string

The name of the table specified in the filter

Row

A data row in a dataset

Name Type Description
id

string

The unique row ID

SensitivityLabel

Sensitivity label info for a Power BI item (such as a report or a dashboard)

Name Type Description
labelId

string

The sensitivity label ID

ServicePrincipalProfile

A Power BI service principal profile. Only relevant for Power BI Embedded multi-tenancy solution.

Name Type Description
displayName

string

The service principal profile name

id

string

The service principal profile ID

Table

A dataset table

Name Type Description
columns

Column[]

The column schema for this table

description

string

The table description

isHidden

boolean

Optional. Whether this dataset table is hidden.

measures

Measure[]

The measures within this table

name

string

The table name

rows

Row[]

The data rows within this table

source

ASMashupExpression[]

The table source

WorkspaceInfo

Workspace info details

Name Type Description
capacityId

string

The workspace capacity ID

dashboards

WorkspaceInfoDashboard[]

The dashboards associated with this workspace. The list of dashboard properties returned varies for different API calls, so you might not see all dashboard properties in an API response.

dataRetrievalState

string

The workspace data retrieval state

dataflows

WorkspaceInfoDataflow[]

The dataflows associated with this workspace. The list of dataflow properties returned varies for different API calls, so you might not see all dataflow properties in an API response.

datamarts

WorkspaceInfoDatamart[]

The datamarts associated with this workspace. The list of datamart properties returned varies for different API calls, so you might not see all datamart properties in an API response.

datasets

WorkspaceInfoDataset[]

The datasets associated with this workspace. The list of dataset properties returned varies for different API calls, so you might not see all dataset properties in an API response.

defaultDatasetStorageFormat

DefaultDatasetStorageFormat

The default dataset storage format in the workspace. Returned only when isOnDedicatedCapacity is true

description

string

The workspace description

id

string

The workspace object ID

isOnDedicatedCapacity

boolean

Whether the workspace is assigned to a dedicated capacity

name

string

The workspace name

reports

WorkspaceInfoReport[]

The reports associated with this workspace. The list of report properties returned varies for different API calls, so you might not see all report properties in an API response.

state

string

The workspace state

type

string

The workspace type

users

GroupUser[]

The users with access to the workspace. The list is returned only when explicitly requested. To retrieve a list of users for a classic workspace, use the Azure Active Directory Graph API.

WorkspaceInfoDashboard

A Power BI dashboard returned by WorkspaceInfo APIs. The API returns a subset of the following list of dashboard properties. The subset depends on the API called, caller permissions, and the availability of data in the Power BI database.

Name Type Description
appId

string

The app ID, returned only if the dashboard belongs to an app

dataClassification

string

The data classification tag of a Power BI item (such as a report or a dashboard)

displayName

string

The display name of the dashboard

id

string

The dashboard ID

isReadOnly

boolean

Whether the dashboard is read-only

sensitivityLabel

SensitivityLabel

The sensitivity label

tiles

WorkspaceInfoTile[]

The tiles that belong to the dashboard

users

DashboardUser[]

(Empty value) The dashboard user access details. This property will be removed from the payload response in an upcoming release. You can retrieve user information on a Power BI dashboard by using the Get Dashboard Users as Admin API call, or the PostWorkspaceInfo API call with the getArtifactUsers parameter.

WorkspaceInfoDataflow

The metadata of a dataflow returned by Workspace Info APIs. Below is a list of properties that may be returned for a dataflow. Only a subset of the properties will be returned depending on the API called, the caller permissions and the availability of the data in the Power BI database.

Name Type Description
configuredBy

string

The dataflow owner

datasourceUsages

DatasourceUsage[]

The data source usages

description

string

The dataflow description

endorsementDetails

EndorsementDetails

The endorsement details

misconfiguredDatasourceUsages

DatasourceUsage[]

The data source misconfigured usages

modelUrl

string

A URL to the dataflow definition file (model.json)

modifiedBy

string

The user that modified the dataflow

modifiedDateTime

string

The date and time that the dataflow was last modified

name

string

The dataflow name

objectId

string

The dataflow ID

sensitivityLabel

SensitivityLabel

The sensitivity label

upstreamDataflows

DependentDataflow[]

The list of all the dataflows this item depends on

upstreamDatamarts

DependentDatamart[]

The list of all the datamarts this item depends on

users

DataflowUser[]

(Empty value) The dataflow user access details. This property will be removed from the payload response in an upcoming release. You can retrieve user information on a Power BI dataflow by using the Get Dataflow Users as Admin API call, or the PostWorkspaceInfo API call with the getArtifactUser parameter.

WorkspaceInfoDatamart

A Power BI datamart returned by Workspace Info APIs. The API returns a subset of the following list of datamart properties. The subset depends on the API called, caller permissions, and the availability of data in the Power BI database.

Name Type Description
configuredBy

string

The name of the datamart owner

configuredById

string

The ID of the datamart owner

datasourceUsages

DatasourceUsage[]

The data source usages

description

string

The datamart description

endorsementDetails

EndorsementDetails

The datamart endorsement details

id

string

The datamart ID

modifiedBy

string

The last user that modified the datamart

modifiedById

string

The ID of the last user that modified the datamart

modifiedDateTime

string

The date and time that the datamart was last modified

name

string

The datamart name

sensitivityLabel

SensitivityLabel

The datamart sensitivity label

state

datamartState

The datamart current state

status

datamartStatus

The datamart status

suspendedBatchId

string

datamart suspended batch id

type

datamartType

The datamart type

upstreamDataflows

DependentDataflow[]

The list of all the dataflows this item depends on

upstreamDatamarts

DependentDatamart[]

The list of all the datamarts this item depends on

users

DatamartUser[]

The user access details for a Power BI datamart.

WorkspaceInfoDataset

A Power BI dataset returned by WorkspaceInfo APIs. The API returns a subset of the following list of dataset properties. The subset depends on the API called, caller permissions, and the availability of the data in the Power BI database.

Name Type Description
ContentProviderType

string

The content provider type for the dataset

CreatedDate

string

The dataset creation date and time

configuredBy

string

The dataset owner

datasourceUsages

DatasourceUsage[]

The data source usages

description

string

The dataset description

endorsementDetails

EndorsementDetails

The endorsement details

expressions

Expression[]

The dataset expressions

id

string

The dataset ID

misconfiguredDatasourceUsages

DatasourceUsage[]

The data source misconfigured usages

name

string

The dataset name

roles

Role[]

The dataset roles

schemaMayNotBeUpToDate

boolean

Whether the dataset schema might not be up to date

schemaRetrievalError

string

The dataset schema retrieval error

sensitivityLabel

SensitivityLabel

The sensitivity label

tables

Table[]

The dataset tables

targetStorageMode

string

The dataset storage mode

upstreamDataflows

DependentDataflow[]

The list of all the dataflows this item depends on

upstreamDatamarts

DependentDatamart[]

The list of all the datamarts this item depends on

upstreamDatasets

DependentDataset[]

The upstream datasets

users

DatasetUser[]

(Empty value) The dataset user access details. This property will be removed from the payload response in an upcoming release. You can retrieve user information on a Power BI item (such as a report or a dashboard) by using the Get Dataset Users as Admin API, or the PostWorkspaceInfo API with the getArtifactUsers parameter.

WorkspaceInfoReport

A Power BI report returned by Workspace Info APIs. The API returns a subset of the following list of report properties. The subset depends on the API called, caller permissions, and the availability of data in the Power BI database.

Name Type Description
appId

string

The app ID, returned only if the report belongs to an app

createdBy

string

The report owner. Available only for reports created after June 2019.

createdById

string

The ID of the report owner. Available only for reports created after June 2019.

createdDateTime

string

The report creation date and time

datasetId

string

The dataset ID of the report

datasetWorkspaceId

string

The workspace ID of the related dataset, returned only if the related dataset belongs to a different workspace

description

string

The report description

endorsementDetails

EndorsementDetails

The endorsement details

id

string

The report ID

isOwnedByMe

boolean

Determine if the report is created by the current user.

modifiedBy

string

The last user that modified the report

modifiedById

string

The ID of the last user that modified the report

modifiedDateTime

string

The date and time that the report was last modified

name

string

The name of the report

originalReportId

string

The actual report ID when the workspace is published as an app.

reportType enum:
  • PaginatedReport
  • PowerBIReport

The report type

sensitivityLabel

SensitivityLabel

The sensitivity label

users

ReportUser[]

(Empty value) The user access details for a Power BI report. This property will be removed from the payload response in an upcoming release. You can retrieve user information on a Power BI report by using the Get Report Users as Admin API call, or the PostWorkspaceInfo API call with the getArtifactUsers parameter.

WorkspaceInfoResponse

Workspace info response

Name Type Description
datasourceInstances

Datasource[]

The data source instances associated with this scan

misconfiguredDatasourceInstances

Datasource[]

The data source misconfigured instances associated with this scan

workspaces

WorkspaceInfo[]

The workspace info associated with this scan

WorkspaceInfoTile

A Power BI tile returned by WorkspaceInfo APIs

Name Type Description
datasetId

string

The dataset ID. Available only for tiles created from a report or by using a dataset, such as Q&A tiles.

datasetWorkspaceId

string

The workspace ID of the related dataset, returned only if the related dataset belongs to a different workspace

id

string

The tile ID

reportId

string

The report ID. Available only for tiles created from a report.

title

string

The display name of the tile