The Power BI workspace and dataset to use.

Data Type

string

Default Value

""

Remarks

The connector 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 connector 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 connector 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 connector cannot determine the workspace and dataset automatically from an MDX query.