The Power BI workspace and dataset to use.

Data Type

string

Default Value

""

Remarks

The driver combines each Power BI workspace and dataset into a single catalog name. For example, if you have a workspace called MyWorkspace and a dataset called MyDataset then its catalog name will be MyWorkspace_MyDataset.

By default the driver will report all workspaces and datasets as separate catalogs. A query can either use the catalog directly, or leave off the catalog to have the driver search for a matching table.

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

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

However, if you have enabled UseMDX then you may want to set this value so that MDX queries go to the correct workspace and dataset. The driver cannot determine the workspace and dataset automatically from an MDX query.