BI_ASSET_DETAILS table
The BI_ASSET_DETAILS table contains BI-specific attributes for business intelligence assets across PowerBI, Tableau, Looker, and Sigma connectors.
note
This table contains only BI-specific columns. Common asset attributes (name, description, owners, etc.) are available in the ASSETS table. Join on guid to enrich BI asset data with these attributes.
Source tables
This table consolidates data from the following entity types: PowerBIDashboard, PowerBIReport, PowerBIDataset, TableauDashboard, TableauWorkbook, LookerDashboard, SigmaWorkbook, SigmaPage, SigmaDataElement, SigmaDataset, SigmaDataElementField, SigmaDatasetColumn.
Columns
The BI_ASSET_DETAILS table includes the following columns:
| Column | Description |
|---|---|
guid | The asset's globally-unique identifier |
asset_type | The type of BI asset (for example, PowerBIDashboard, TableauWorkbook, SigmaPage) |
status | The asset's status (for example, ACTIVE, DELETED) |
workspace_qualified_name | Qualified name of the PowerBI workspace |
project_qualified_name | Qualified name of the Tableau project |
folder_name | Display name of the Looker folder |
site_qualified_name | Qualified name of the Tableau site |