Specifies the Power BI workspace and dataset to use, combined into a single catalog name. For example, MyWorkspace_MyDataset. Leave this blank to search across all available workspaces and datasets.

Data Type

string

Default Value

""

Remarks

The driver combines each Power BI workspace and dataset into a single catalog name. The catalog name is constructed by appending the dataset name to the workspace name, separated by an underscore. For example, if the workspace is called MyWorkspace and the dataset is called MyDataset, the catalog name will be MyWorkspace_MyDataset. By default, the driver lists all workspaces and datasets as separate catalogs. You can query a specifc catalog by specifying a name or search for a table across all catalogs:

-- Use this specific catalog
SELECT ... FROM MyWorkspace_MyDataset.Model.MyDimension

-- Search for a catalog containing this table
SELECT ... FROM Model.MyDimension

When you enable UseMDX, set this property to route MDX queries to the correct workspace and dataset. The driver cannot automatically detect the workspace and dataset for MDX queries.